Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Nested Formula - HELP
Here are the formulas I am trying to put together into one formula but cannot
seem to get it right. IF((AND($I$5="",$J$5="") IF TRUE THEN DO THE FOLLOWING CALCULATION: SEE IF ONE OF THE FOLLOWING APPLY: OR($G$5=K3,$G$5<=K2),1,""), OR($H$5=K3,$H$5<=K2),1,"") IF FALSE DO THE FOLLOWING: SEE IF ONE OF THE FOLLOWING APPLY: OR($I$5=T3,$I$5<=K2),1,""), OR($J$5=K3,$J$5<=K2),1,"") Any help will be appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with formula €“ too many nested IFs | Excel Worksheet Functions | |||
Nested Formula help | Excel Worksheet Functions | |||
nested formula | Excel Worksheet Functions | |||
Nested Formula | Excel Worksheet Functions | |||
Nested Formula | Excel Worksheet Functions |