ExcelBanter - Adding to formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Adding to formula (https://www.excelbanter.com/excel-discussion-misc-queries/241568-adding-formula.html)

Canon

Adding to formula

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

Adding to formula

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
---------------
Jacob Skaria

"Canon" wrote:

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

Stefi

Adding to formula

=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:

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

All times are GMT +1. The time now is 02:58 PM.