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)))))))))