Adding to formula

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...
 
J

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
 
S

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:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Min. Formula 2
Combine 2 formulas 14
Want To Shrink Formula 1
How do I create a 26 'tier' IF formula? 5
Add formula to a column of numbers 6
Sort data 2
If condition to find Target 2
Subtotal and IF Formula 1

Top