# If OR statement issue

#### rememberthecoop

##### New Member
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?

### Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.

#### MrKowz

##### Well-known Member
Welcome to the forums!

Try:

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

#### VoG

##### Legend
Try

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

Replies
19
Views
221
Replies
2
Views
53
Replies
0
Views
37
Replies
5
Views
1K
Replies
3
Views
16

1,109,359
Messages
5,528,222
Members
409,809
Latest member
VICKRAM

### This Week's Hot Topics

• Change military grades into rank
Afternoon all Need help with formula that will change military rank (i.e. 1, 2, 3 into Amn, A1C, SrA). Running IF formula that does not work...
• VBA COUNTIF SOLUTION
Hi The following are the errors spread across the several columns from E to Q ie. 13 columns across several sheets with more than 500 rows per...
• INSERT ROW WITH SPECIFIS TEXT IN A COLUMN
Hi All! How can identify that that the row to be inserted has to be inserted before 1st row with specific text in column F. If I record the...