If statements - MS Excel - Status from Suffix

tezza73
tezza73 used Ask the Experts™
on
Hi Gurus

Spreadsheet self explanatory. Please advise.

Regards

tez

EE-IFSTATUS.xls
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
You can use the formula

=IF(OR(RIGHT(D2,1)="D",OR(RIGHT(D2,1)="S")),"Staff",IF(RIGHT(D2,1)="A","ASW",""))

See attached excel file
EE-IFSTATUS.xls
Most Valuable Expert 2013
Commented:
You could shorten Srikanth's suggested formula a little, no real need for 2 OR functions

=IF(OR(RIGHT(D2)={"D","S"}),"Staff",IF(RIGHT(D2)="A","ASW",""))

regards, barry

Author

Commented:
Thanks Guys, if you don't mind both solutions were correct so rather than disappoint have split the points. You guys are so good.
Regards
tezza

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial