Excel 2010 - IF OR Statement

[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

 

[Brian from Maui]

Something like,

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

 

[kevinb11]

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"))))

 

[Weazel]

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"}))

 

[ukmikeb]

Hi

Try :-

=IFERROR(CHOOSE($X3,"Received","In Progress","Testing","Completed"),"Awaiting")

hth

 

[Johnny Thunder]

All worked perfectly!!! Thanks!