| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Max IF Statement Q
Could anyone tell me if I have exceeded the allowed number of IF statements
in the formula below? It seems to stop working correctly at the second formula below - is there a work around? =IF(Masters!K1="London",(IF(AND(AA10<18),'JLC Rates'!D$14,(IF(AND(AA12<1,AA10=18),'JLC Rates'!D$10,(IF(AND(AA121,AA10<19,AA10=18),'JLC Rates'!D$10,IF(AND(AA121,AA10=19),'JLC Rates'!D$12,""))))))),(IF(AND(AA10<18),'JLC Rates'!G$14,(IF(AND(AA12<1,L10=18),'JLC Rates'!G$10,(IF(AND(AA121,AA10<19,AA10=18),'JLC Rates'!G$10,IF(AND(AA121,AA10=19),'JLC Rates'!G$12,"")))))))) Part of above (IF(AND(AA10<18),'JLC Rates'!G$14,(IF(AND(AA12<1,L10=18),'JLC Rates'!G$10,(IF(AND(AA121,AA10<19,AA10=18),'JLC Rates'!G$10,IF(AND(AA121,AA10=19),'JLC Rates'!G$12,"")))))))) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF Statement with Average Function results in #Value! | Excel Discussion (Misc queries) | |||
| 7+ nested if statement? | Excel Worksheet Functions | |||
| Statement | Excel Worksheet Functions | |||
| Duplicate fields does not match up! If statement | Excel Worksheet Functions | |||
| If statement needed | Excel Worksheet Functions | |||
Threaded Mode
