If, And, Or Formula
get rid of the open paren in front of $I$5
"Clara" wrote:
I need help, basically if B8 is equal to the following and attributes and E5
is equal to the other attributes, and I5 is greater than 19, then yes.
I get an error when using the following formula, and I'm not sure if it's a
parenthesis missing or a comma out of place. Can someone help me with this.
=IF(AND(OR($B$8="FAPI",$B$8="PAPI",$B$8="EXPAT",$B $8="INPAT"),$E$5="A",$E$5="L",$E$5="P",$E$5="U",($ I$519),"Y","N"))
|