Thread: [Solved] What formula to use
View Single Post
 
Old 04-05-2016, 12:28 PM
gebobs gebobs is offline Windows 7 64bit Office 2010 64bit
Expert
  
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default
Try this:

Code:
=IF(OR(A2="HOME",A2="OUTPATIENT"),"OUTPATIENT",A2)
Reply With Quote