If OR statement issue

[rememberthecoop]

Hi -
What I'm trying to do in Excel is create a simple cell decoder.

Something like if A1=1, then cat or if A1=2, then dog or if A1 is null, then leave cell blank.

Here's what I have so far that is not working.
=IF(OR(A1="1", "cat"), OR(A1="2", "dog")),"")

Any ideas?
Thanx in advance

 

[MrKowz]

Welcome to the forums!

Try:

=IF(OR(A1={"",0}),"",CHOOSE(A1,"Cat","Dog"))

 

[VoG]

Try

=IF(A1=1,"cat",if(A1=2,"dog",""))