Sep 21 2022 06:20 PM - edited Sep 21 2022 06:23 PM
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",3,4)))
Bird =IF(A5>="Cat",1, IF(A5>="Dog",2, IF(A5>="Bird",3,4)))
But when I enter, it shows me like this:
Cat 1
Dog 1
Bird 3
So, what is this happening, if anyone knows what problem is, please tell me how to fix it, I'm here to thank you in advance.
Sep 21 2022 06:34 PM
Sep 21 2022 06:36 PM
Sep 21 2022 07:12 PM
Sep 21 2022 07:42 PM
@Y2135 I'm not sure how to do it with if function... What about using a vlookup?
Attached is an example.
Sep 22 2022 12:47 AM - edited Sep 22 2022 12:52 AM
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)))