Forum Discussion
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,...
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.