| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Quick help with a simple function!
Hi all, first time posting here.
I'm just working on a command for a sheet here at work and I think I must have been staring at it for too long. The sequence below returns an error and excel won't accept it as a formula. I think I'm missing an outcome, but I can't see where, cheers, =IF(B9=0,0,(IF(C9="TPL",VLOOKUP(B9,Q7:Y32,9,FALSE) ,IF(B9=Q22,Z22,IF(B9=Q21,Z21,IF(B9=Q20,Z20,IF(H9=" Y",IF(C950000,(C9-50000)*E9*F9*I9,0),IF(VLOOKUP(B9,Q7:W32,7,FALSE)I F(C9200000,IF(G9=1.1,(C9-200000)*E9*F9*G9*I9*0.75+200000*E9*F9*G9*I9,(C9-200000)*E9*F9*I9*0.75+200000*E9*F9*I9),IF(G9=1.1,C 9*E9*F9*G9*I9,C9*E9*F9*I9)),VLOOKUP(B9,Q7:W32,7,FA LSE),IF(C9200000,IF(G9=1.1,(C9-200000)*E9*F9*G9*I9*0.75+200000*E9*F9*G9*I9,(C9-200000)*E9*F9*I9*0.75+200000*E9*F9*I9),IF(G9=1.1,C 9*E9*F9*G9*I9,C9*E9*F9*I9))))))))) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Custom function | Excel Worksheet Functions | |||
| Simple IF function query (hopefully) | Excel Discussion (Misc queries) | |||
| Creating a Custom Excel Function to Calculate Gini Coefficients | Excel Worksheet Functions | |||
| Function formula for simple worksheet | New Users to Excel | |||
| Simple Function Help ~ Please | Excel Worksheet Functions | |||
Threaded Mode
