Excel 2010 - IF OR Statement

Thanks:  0
Likes:  0

# Thread: Excel 2010 - IF OR Statement

1. ## Excel 2010 - IF OR Statement

Hello all,

Need help writing and IF OR statement.

In cell X3 I have an AUTOSUM that counts from 1-4 and I need cell Y3 to relay a comment based on what cell X3 returns,

If 1="Received"
If 2="In Progress"
If 3="Testing"
If 4="Completed"
If blank="Awaiting"

Any help is appreciated. Thanks

2. ## Re: Excel 2010 - IF OR Statement

Something like,

=IF(X3="","waiting",LOOKUP(X3,{1,2,3,4},{"a","b","c","d"}))

3. ## Re: Excel 2010 - IF OR Statement

Originally Posted by Johnny Thunder
Hello all,

Need help writing and IF OR statement.

In cell X3 I have an AUTOSUM that counts from 1-4 and I need cell Y3 to relay a comment based on what cell X3 returns,

If 1="Received"
If 2="In Progress"
If 3="Testing"
If 4="Completed"
If blank="Awaiting"

Any help is appreciated. Thanks
Enter the below formula in Y3

=IF(X3=1,"Received",IF(X3=2,"In Progress",IF(X3=3,"Testing",IF(X3=4,"Completed","Awaiting"))))

4. ## Re: Excel 2010 - IF OR Statement

Well, figured since I typed it I'd post it though Brian was a bit faster

=IF(X3="","Awaiting",LOOKUP(X3,{1,2,3,4},{"Received","In Progress","Testing","Completed"}))

5. ## Re: Excel 2010 - IF OR Statement

Hi

Try :-
Code:
`=IFERROR(CHOOSE(\$X3,"Received","In Progress","Testing","Completed"),"Awaiting")`
hth

6. ## Re: Excel 2010 - IF OR Statement

All worked perfectly!!! Thanks!

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•