Feb 26 2019 02:50 AM
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?
Feb 26 2019 03:03 AM
Your exact formula returns 3
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.
Feb 26 2019 03:05 AM
Feb 26 2019 03:26 AM
Thank you - just checked and the WORDTHREE was actually in capitals and the formula was Wordthree which was causing this !
Feb 26 2019 04:28 AM
That doesn't matter, comparison here is not case sensitive. Try
=IF("WORDTHREE"="Wordthree", "Same", "Different")