gimli
10-04-2010, 10:45 AM
Hey all,
Beating my head in trying to return a value for this statement if "false"
=IF(AND($F$8=6,AL21<0.18,BM21="YES"),"T",IF(BM21="YES",IF(OR($F$8=55,$F$8=54,$F$8=56,$F$8=64,$F$8=61,$F$8=65,$F$8=62,$F$8=67,$F$8 =70,$F$8="X",$F$8=69,$F$8=615),"OK")))
Thought adding this would work but doesnt..see red. Trying to return "nope" instead of false.
=IF(AND($F$8=6,AL21<0.18,BM21="YES"),"T",IF(BM21="YES",IF(OR($F$8=55,$F$8=54,$F$8=56,$F$8=64,$F$8=61,$F$8=65,$F$8=62,$F$8=67,$F$8 =70,$F$8="X",$F$8=69,$F$8=615),"OK","NOPE")))
Thanks much
Beating my head in trying to return a value for this statement if "false"
=IF(AND($F$8=6,AL21<0.18,BM21="YES"),"T",IF(BM21="YES",IF(OR($F$8=55,$F$8=54,$F$8=56,$F$8=64,$F$8=61,$F$8=65,$F$8=62,$F$8=67,$F$8 =70,$F$8="X",$F$8=69,$F$8=615),"OK")))
Thought adding this would work but doesnt..see red. Trying to return "nope" instead of false.
=IF(AND($F$8=6,AL21<0.18,BM21="YES"),"T",IF(BM21="YES",IF(OR($F$8=55,$F$8=54,$F$8=56,$F$8=64,$F$8=61,$F$8=65,$F$8=62,$F$8=67,$F$8 =70,$F$8="X",$F$8=69,$F$8=615),"OK","NOPE")))
Thanks much