| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Simplifying IF Statement
I would like to simplify (reduce) the number of IF statements in this
formula: - =IF(H901,G90*M90*P90,IF(I901,G90*M90*P90,IF(J90 1,G90*M90*P90,IF(K901,G90*M90*P90,IF(L901,G90*M9 0*P90,(G90*7850*(N90/1000*O90/1000*Q90))))))) Without a Macro, as there is already macros operating elsewhere in the spreadsheet. I was thinking of something like: =IF(H90:L901,G90*M90*P90,,(G90*7850*(N90/1000*O90/1000*Q90)), but this returns a #VALUE error. Can anyone help? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Code needs simplifying | Excel Worksheet Functions | |||
| Simplifying VBA code | Excel Worksheet Functions | |||
| Simplifying a formula | Excel Worksheet Functions | |||
| Simplifying formula | Excel Discussion (Misc queries) | |||
| Simplifying VBA code | Excel Programming | |||
Threaded Mode
