Forum Discussion

Jimbobmcwalton's avatar
Jimbobmcwalton
Brass Contributor
Feb 26, 2019

IF Function

Hi There,    I am trying to get Excel to show a result of 3 in a cell if 3 different cells contain WORDONE WORDTWO & WORDTHREE   Im using     =IF(OR(V4="WORDONE",W4="WORDTWO",X4="WORDTHREE"),3,...
excel
Formulas and Functions
Twifoo's avatar
Twifoo
Silver Contributor
Feb 26, 2019
Check the values of V4:X4. None of them might be equal to any of the values specified in the arguments of the OR function.
  • Jimbobmcwalton's avatar
    Jimbobmcwalton
    Brass Contributor
    Feb 26, 2019

    Thank you - just checked and the WORDTHREE was actually in capitals and the formula was Wordthree which was causing this !

     

     

    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Feb 26, 2019

      That doesn't matter, comparison here is not case sensitive. Try

      =IF("WORDTHREE"="Wordthree", "Same", "Different")

Resources