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