What formula to use

[jomwelsh]

Hi,

Please help with formula on the attached with several conditions.




Thank you,
Jocelyn

[Pecoflyer]

Please explain in words what you are trying to do. Thank you

[jomwelsh]

Originally Posted by Pecoflyer

Please explain in words what you are trying to do. Thank you

I want column A to return as indicated in column B. Example Home and Outpatient should return as Outpatient

Thanks much

[gebobs]

Try this:

=IF(OR(A2="HOME",A2="OUTPATIENT"),"OUTPATIENT",A2)

[jomwelsh]

Originally Posted by gebobs

Try this:

=IF(OR(A2="HOME",A2="OUTPATIENT"),"OUTPATIENT",A2)

Thank you so much Gebobs.

Can you please another condition to the effect that all others will return as Inpatient?

[gebobs]

=if(or(a2="home",a2="outpatient"),"outpatient","inpatient")

[jomwelsh]

Wow, it works (of course), thank you so much.

one last request - how about if I add another destination - 23 HR to return as 23 HR?
Sorry but this is definitely my last question on this subject. Thank you in advance Gebobs!