Feb 15 2022 06:30 AM
I want to set it this way
If C5= Apple or orange or grape
E5= Please clean the fruit
I kept trying if or but cant seem to get it right . If either one of the three are selected in
c5 the answer should be the same in E5
Feb 15 2022 06:47 AM
=IF(OR(LOWER(C5)={"apple","orange","grape"}),"Please clean the fruit","")
Feb 15 2022 06:48 AM
Hi @Xeryar
in E5
=IF(
OR(
C5="apple",
C5="orange",
C5="grape"
);
"Please clean the fruit",
"Do nothing"
)
an alternative:
=IF(
SUM(
COUNTIF(C5,{"apple","orange","grappe"})
),
"Please clean the fruit",
"Do nothing"
)
Feb 15 2022 07:04 AM
Feb 15 2022 07:06 AM
Feb 15 2022 07:10 AM
You forgot some double quotes, and your texts are in upper case instead of lower case.
=IF(OR(UPPER(E9)={"BIG JOE LIFT TRUCKS-SHANGHAI","I-LIFT EQUIPMENT INC-SHANGHAI"}),Please contact the vendor directly","")
Feb 15 2022 07:26 AM
@Hans Vogelaar hi bud its still not working not sure what i am missing . i have attached the document
Feb 15 2022 11:07 AM
SolutionSee the attached version.
Feb 15 2022 11:07 AM
Solution