SOLVED

IF OR function

%3CLINGO-SUB%20id%3D%22%5C%26quot%3Blingo-sub-3167780%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3EIF%20OR%20function%26lt%3B%5C%2Flingo-sub%26gt%3B%3CLINGO-BODY%20id%3D%22%5C%26quot%3Blingo-body-3167780%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CP%3EI%20want%20to%20set%20it%20this%20way%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EIf%20C5%3D%20Apple%20or%20orange%20or%20grape%26nbsp%3B%3CBR%20%2F%3EE5%3D%20Please%20clean%20the%20fruit%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EI%20kept%20trying%20if%20or%20but%20cant%20seem%20to%20get%20it%20right%20.%20If%20either%20one%20of%20the%20three%20are%20selected%20in%26nbsp%3B%3CBR%20%2F%3Ec5%20the%20answer%20should%20be%20the%20same%20in%20E5%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%26lt%3B%5C%2Flingo-body%26gt%3B%3CLINGO-LABS%20id%3D%22%5C%26quot%3Blingo-labs-3167780%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CLINGO-LABEL%3EExcel%26lt%3B%5C%2Flingo-label%26gt%3B%26lt%3B%5C%2Flingo-labs%26gt%3B%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3C%2FLINGO-SUB%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3167780%22%20slang%3D%22en-US%22%3EIF%20OR%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3167780%22%20slang%3D%22en-US%22%3E%3CP%3EI%20want%20to%20set%20it%20this%20way%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EIf%20C5%3D%20Apple%20or%20orange%20or%20grape%26nbsp%3B%3CBR%20%2F%3EE5%3D%20Please%20clean%20the%20fruit%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EI%20kept%20trying%20if%20or%20but%20cant%20seem%20to%20get%20it%20right%20.%20If%20either%20one%20of%20the%20three%20are%20selected%20in%26nbsp%3B%3CBR%20%2F%3Ec5%20the%20answer%20should%20be%20the%20same%20in%20E5%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3167780%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Contributor

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 

7 Replies

@Xeryar 

=IF(OR(LOWER(C5)={"apple","orange","grape"}),"Please clean the fruit","")

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"
)
=IF(SUM(COUNTIF(E9,{"BIG JOE LIFT TRUCKS-SHANGHAI","I-LIFT EQUIPMENT INC-SHANGHAI}),Please contact the vendor directly","")

=IF(OR(E9="BIG JOE LIFT TRUCKS-SHANGHAI,"I-LIFT EQUIPMENT INC-SHANGHAI");"Please contact the vendor directly,"")

I tried both but they didnt worked
=IF(OR(LOWER(E9)={BIG JOE LIFT TRUCKS-SHANGHAI,"I-LIFT EQUIPMENT INC-SHANGHAI"}),Please contact the vendor directly","")
This didn't worked

@Xeryar 

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

@Hans Vogelaar hi bud its still not working not sure what i am missing . i have attached the document 

best response confirmed by Xeryar (Occasional Contributor)
Solution

@Xeryar 

See the attached version.