Microsoft Office Forums - View Single Post - [Solved] What formula to use

Thread: [Solved] What formula to use

View Single Post

Old

04-06-2016, 12:33 PM

jomwelsh

jomwelsh is offline

jomwelsh uses Windows 10

Windows 10 jomwelsh uses Office 2013

jomwelsh uses Office 2013

Office 2013

Novice

The original poster

Join Date: Apr 2016

Posts: 4

jomwelsh is on a distinguished road

Default

Quote:

Originally Posted by gebobs

View Post

Try this:

Code:

=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?

Reply With Quote