Adding to formula

  • Thread starter Thread starter Canon
  • Start date Start date
C

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...
 
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
 
=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:
 
Back
Top