If, And, Or Formula
 

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"))

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"))

If, And, Or Formula
 

=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")

"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"))

If, And, Or Formula
 

you also need another or
=IF(AND(OR($B$8="FAPI",$B$8="PAPI",$B$8="EXPAT",$B $8="INPAT"),or($E$5="A",$E$5="L",$E$5="P",$E$5="U" ),$I$519),"Y","N"))

"bj" wrote:

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"))

If, And, Or Formula
 

....well spotted. I missed the other "OR".

"bj" wrote:

you also need another or
=IF(AND(OR($B$8="FAPI",$B$8="PAPI",$B$8="EXPAT",$B $8="INPAT"),or($E$5="A",$E$5="L",$E$5="P",$E$5="U" ),$I$519),"Y","N"))

"bj" wrote:

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"))

If, And, Or Formula
 

Hi,

=IF(AND(OR($B$8="FAPI",$B$8="PAPI",$B$8="EXPAT",$B $8="INPAT"),OR($E$5="A",$E$5="L",$E$5="P",$E$5="U" ),$I$519),"Y","N")

Thanks,
--
Farhad Hodjat


"Toppers" wrote:

=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")

"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"))

If, And, Or Formula
 

You could shorten it slightly if you used array constants:

=IF(AND(OR($B$8={"FAPI","PAPI","EXPAT","INPAT"}),O R($E$5={"A","L","P","U"}),$I$519),"Y","N")

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Clara" wrote in message
...
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"))