Hi, I've got the following formula & need to add an IF(AND "Draw", "Sub (Used
+80)".

=IF(AND($F$7="Win",F16="Started"),VLOOKUP(B16,Shee t1!$A$3:$L$31,5,FALSE),IF(AND($F$7="Win",F16="Sub
(Not
Used)"),VLOOKUP(B16,Sheet1!$A$3:$L$31,7,FALSE),IF( AND($F$7="Win",F16="Sub
(Used
-80)"),VLOOKUP(B16,Sheet1!$A$3:$L$31,6,FALSE),IF(AN D($F$7="Win",F16="Sub
(Used
+80)"),VLOOKUP(B16,Sheet1!$A$3:$L$31,6,FALSE),IF(A ND($F$7="Draw",F16="Sub
(Used
-80)"),VLOOKUP(B16,Sheet1!$A$3:$L$31,10,FALSE),IF(A ND($F$7="Draw",F16="Sub
(Not
Used)"),VLOOKUP(B16,Sheet1!$A$3:$L$31,11,FALSE),IF (AND($F$7="Draw",F16="Started"),VLOOKUP(B16,Sheet1 !$A$3:$L$31,9,FALSE),"0")))))))

Now when i do add this it rejects the addition stating that there is an
error. All i'm adding is the same as all the other IF(AND's that are already
in there.
The return amount for the amount of +80 is the same as -80.
If i change the -80 to +80 it works fine but I then can't add -80?
What am i missing?

Thanks

--
EVH5150