View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
bj bj is offline
external usenet poster
 
Posts: 1,397
Default 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"))