| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need formula to I have too many nested level
=IF(O6=P6,P6*K6/J6,IF(O6<P6,O6*K6/J6,IF(O6P6,P6*K6/J6+AQ6*K6/J6*1.5,IF(U6=V6,V6*K6/J6,IF(U6<V6,U6*K6/J6,IF(U6V6,U6*K6/J6+AU6*K6/J6*1.5,IF(aa6=ab6,ab6*K6/J6,IF(aa6<ab6,aa6*K6/J6,IF(aa6ab6,aa6*K6/J6+Ay6*K6/J6*1.5,0))))))
I need this formula but a simplified one can some one please help |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 20 level nested If | Excel Discussion (Misc queries) | |||
| 3 level nested if has too many arguments ? | Excel Discussion (Misc queries) | |||
| 3 level nested if please explain | Excel Discussion (Misc queries) | |||
| another EXPERT LEVEL FORMULA from me | Excel Discussion (Misc queries) | |||
| Limited IF Nested Level functions. | Excel Discussion (Misc queries) | |||
Threaded Mode
