Forum Discussion

X128359's avatar
X128359
Copper Contributor
Jun 25, 2021
Solved

IF function formula if I want 2 words to return same answer

I need an IF function formula for when I want Excel to return the word "affirmative" if the data are the words "Lima" and "Foxtrot" and return the word"negative" if not. I wanted to start a whole Vloo...
excel
  • NikolinoDE's avatar
    NikolinoDE
    Jun 25, 2021

    X128359 

    Here is a formula with IF, as requested.

    =IF(COUNTIF(A9,"*Lima*"),"negative",IF(COUNTIF(A9,"*Foxtrot*"),"negative",$A$5))

     

    Also attached is an Excel file with an example.

     

    I would be happy to know if I could help.

     

    Nikolino

    I know I don't know anything (Socrates)

    * Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.

NikolinoDE's avatar
NikolinoDE
Platinum Contributor
Jun 25, 2021

X128359 

Here is a formula with IF, as requested.

=IF(COUNTIF(A9,"*Lima*"),"negative",IF(COUNTIF(A9,"*Foxtrot*"),"negative",$A$5))

 

Also attached is an Excel file with an example.

 

I would be happy to know if I could help.

 

Nikolino

I know I don't know anything (Socrates)

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.

X128359's avatar
X128359
Copper Contributor
Jun 28, 2021
I aslo tried your idea! It also worked, a bit longer than Riny but aslo did the trick. Thanks for teaching me something new.. already thinking where else I can apply this solution!

Resources