| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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... |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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... |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding to a formula | Excel Discussion (Misc queries) | |||
| Adding on to a formula | Excel Worksheet Functions | |||
| adding a formula | Excel Discussion (Misc queries) | |||
| adding a formula including the value another formula gets | Excel Discussion (Misc queries) | |||
| Formula help : adding | New Users to Excel | |||
Linear Mode
