Error on Nested If Statement

Hi There - the Shaolin Masters of this Forum may be able to tell in a fleeting glance whats wrong with your formula but for the avg joe like me it'd b really helpful if u were to upload a spreadsheet.

I bet Dll has responded already!

Originally Posted by Blake 7

I bet Dll has responded already!

Not quite......

Try this

=IF(C2="Line 10",200,IF(OR(C2={"Line 1","Line 5"}),IF(AI>50,200,240),IF(OR(C2={"Line 2","Line 4","Line 6","Line 3"}),IF(A1>80,150,170),IF(C2="Line 9",VLOOKUP("95 Number",'Product Table'!N1:P309,3,FALSE)))))

I put quotes around "95 number" too.....is that right?

Because of missing parentheses, your formula becomes a little ambigous so we're trying to guess what IF/Then, True/False senarios you're working with.

I would put a parentheses after your first 240 and quotes around "95 number" Also, you have Ai>50, guessing that should be A1>50

With complex IF statements like this I try to do some sort of flowchart to see if it's doing what I want it to do. See attached.

One last thing, The VLOOKUP will always return the same thing assuming your Product table is static and "95 Number" is not a defined name. Is that what you want?

And finally (okay, that wasn't the last thing), If you respond to false all the way through your IF statement (assuming you have 10 lines, then if line 7 or 8), you end up with "FALSE" in your cell. Did you want that?

Originally Posted by ChemistB

Also, you have Ai>50, guessing that should be A1>50

Good call