Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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")) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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")) |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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")) |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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")) |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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")) |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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")) |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
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")) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|