Home

IF Function

Jimbobmcwalton
Contributor

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

 

The formula keeps returning a result of 1 no matter if I use AND (or) OR 

 

Any ideas?

4 Replies
Highlighted

Your exact formula returns 3

image.png

but perhaps you need something like

=(V4="WORDONE")+(W4="WORDTWO")+(X4="WORDTHREE")

which returns the number from zero to 3, depends on how many matches. That's if order of words matters, If not, it'll be another formula.

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.

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

 

 

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

=IF("WORDTHREE"="Wordthree", "Same", "Different")
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies