If Statement returns "FALSE"

[shawnamillion]

Hey guys,

I understand you get a "FALSE" from your IF statement when the criteria of the IF statement are not met and you did not provide an 'else' option. However, I did provide an 'else' option and still I keep getting "FALSE", instead of the else option which is "FAIL". Any help is greatly appreciated. I have been battling this formula for hours!

=IF($B5="","",IF('Order form'!$L4="F",IF(AND('Measurements with Shrinkage'!$B4>='Spec Sheet with Tolerences'!B$17,'Measurements with Shrinkage'!$B4<='Spec Sheet with Tolerences'!C$17,'Measurements with Shrinkage'!$E4>='Spec Sheet with Tolerences'!B$20,'Measurements with Shrinkage'!$E4<='Spec Sheet with Tolerences'!C$20,'Measurements with Shrinkage'!$F4>='Spec Sheet with Tolerences'!B$22,'Measurements with Shrinkage'!$F4<='Spec Sheet with Tolerences'!C$22,'Measurements with Shrinkage'!$G4>='Spec Sheet with Tolerences'!B$21,'Measurements with Shrinkage'!$G4<='Spec Sheet with Tolerences'!C$21),IF('Measurements with Shrinkage'!$C4-'Spec Sheet'!B$19>='Measurements with Shrinkage'!$D4-'Spec Sheet'!B$20,IF(AND('Measurements with Shrinkage'!$C4>='Spec Sheet with Tolerences'!B$18,'Measurements with Shrinkage'!$C4<='Spec Sheet with Tolerences'!C$18),"PASS",IF('Measurements with Shrinkage'!$D4-'Spec Sheet'!B$20>'Measurements with Shrinkage'!$C4-'Spec Sheet'!B$19,IF(AND('Measurements with Shrinkage'!$D4>='Spec Sheet with Tolerences'!B$19,'Measurements with Shrinkage'!$D4<='Spec Sheet with Tolerences'!C$19),"PASS","FAIL")))))))

[Speshul]

You don't have anything in the value_if_false for one or more of those IF statements


--------------------------

Edit: There are a few, after each of these commas (highlighted in red at the end) there should be an if_false statement:
=IF($B5="","",IF('Order form'!$L4="F",IF(AND('Measurements with Shrinkage'!$B4>='Spec Sheet with Tolerences'!B$17,'Measurements with Shrinkage'!$B4<='Spec Sheet with Tolerences'!C$17,'Measurements with Shrinkage'!$E4>='Spec Sheet with Tolerences'!B$20,'Measurements with Shrinkage'!$E4<='Spec Sheet with Tolerences'!C$20,'Measurements with Shrinkage'!$F4>='Spec Sheet with Tolerences'!B$22,'Measurements with Shrinkage'!$F4<='Spec Sheet with Tolerences'!C$22,'Measurements with Shrinkage'!$G4>='Spec Sheet with Tolerences'!B$21,'Measurements with Shrinkage'!$G4<='Spec Sheet with Tolerences'!C$21),IF('Measurements with Shrinkage'!$C4-'Spec Sheet'!B$19>='Measurements with Shrinkage'!$D4-'Spec Sheet'!B$20,IF(AND('Measurements with Shrinkage'!$C4>='Spec Sheet with Tolerences'!B$18,'Measurements with Shrinkage'!$C4<='Spec Sheet with Tolerences'!C$18),"PASS",IF('Measurements with Shrinkage'!$D4-'Spec Sheet'!B$20>'Measurements with Shrinkage'!$C4-'Spec Sheet'!B$19,IF(AND('Measurements with Shrinkage'!$D4>='Spec Sheet with Tolerences'!B$19,'Measurements with Shrinkage'!$D4<='Spec Sheet with Tolerences'!C$19),"PASS","FAIL"),)),),),))

[arlu1201]

Thread posted in Commercial services, hence closed.