Forum Discussion
Excel if have problem.
Hi everyone, please help me, I don't know why my if so weird, for example I type: Cat =IF(A3>="Cat",1, IF(A3>="Dog",2, IF(A3>="Bird",3,4))) Dog =IF(A4>="Cat",1, IF(A4>="Dog",2, IF(A4>="Bird"...
Because you are comparing strings. What excel is doing is sorting the strings like this:
1 Bird
2 Cat
3 Dog
So, in the second if, is comparing Dog > Cat that would be 3 > 2 that is True , so is returning 1.
1 Bird
2 Cat
3 Dog
So, in the second if, is comparing Dog > Cat that would be 3 > 2 that is True , so is returning 1.
Your formula is correct only thing there is no need to add < or > as it requires only in Number as text does not have any value. So simply apply the same formula without < or >.
=IF(A3="Cat",1,IF(A3="Dog",2,IF(A3="Bird",3,4)))- Sorry, forgot to explain that is sorting the strings in alphabetic order.
- Ok, so how do I use if to type like this：
Cat 1
Dog 2
Bird 3Y2135 I'm not sure how to do it with if function... What about using a vlookup?
Attached is an example.
