Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page What formula to use What formula to use
Register FAQ

Reply
 
Thread Tools Display Modes
  #1  
Old 04-05-2016, 11:38 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline What formula to use Windows 7 64bit What formula to use Office 2010 64bit
Expert
  
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,943
Pecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond repute
Default
Please explain in words what you are trying to do. Thank you
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #2  
Old 04-05-2016, 12:05 PM
jomwelsh jomwelsh is offline What formula to use Windows 10 What formula to use Office 2013
Novice
What formula to use 		 
Join Date: Apr 2016
Posts: 4
jomwelsh is on a distinguished road
Default
Quote:
Originally Posted by Pecoflyer View Post
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
Reply With Quote
  #3  
Old 04-05-2016, 12:28 PM
gebobs gebobs is offline What formula to use Windows 7 64bit What formula to use 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
  #4  
Old 04-06-2016, 12:33 PM
jomwelsh jomwelsh is offline What formula to use Windows 10 What formula to use Office 2013
Novice
What formula to use 		 
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
Reply

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
What formula to use Need help with IF formula SMI Word 3 01-19-2016 06:33 AM
Need help with dragging a formula and changing a reference column as I drag the formula. LupeB Excel 1 10-22-2015 03:02 PM
What formula to use WHEN formula agent007 Excel 5 02-06-2014 09:20 PM
Formula Help clo312 Excel 11 01-11-2014 02:54 AM
What formula to use What formula should I use? TotalONE Excel 3 11-26-2013 01:30 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:44 AM.

Contact Us - Privacy Statement - Top

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft