Adding to formula

[Canon]

Excel 2007
I would like to add this formula: =IF($B$2="Test",
to the following formula: =CEILING(100*(K7*$H$9),5)/100
And then be able to add further ifs to this.
ie.
=IF($B$2="Test",=CEILING(100*(K7*$H$9),5)/100,IF($B$2="ROAD",=CEILING(100*(K7*$H$12),5)/100...

 

[Jacob Skaria]

Try

=IF($B$2="Test",CEILING(100*(K7*$H$9),5)/100,
IF($B$2="ROAD",CEILING(100*(K7*$H$12),5)/100,""))

If this post helps click Yes

 

[NBVC]

Something like this:

=CEILING(100*(K7*IF($B$2="Test",$H$9,IF($B$2="ROAD",$H$12,0))),5)/100

add extra nested...IF's where the 0 is... but beware that if you are in
Excel 2003 or earlier, you have a small limit of nested functions (7)...
if you have more, then you will need another method.


--
NBVC

Where there is a will there are many ways.

'The Code Cage' (http://www.thecodecage.com)

 

[Stefi]

=IF($B$2="Test",CEILING(100*(K7*$H$9),5)/100,IF($B$2="ROAD",CEILING(100*(K7*$H$12),5)/100,"otherwise"))

How many IFs do you want to nest? If more then 7, then choose another way!

Regards,
Stefi

„Canon†ezt írta: