 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / March 2008Formula help
I need help with the following problem. Example Cell H13 is either left blank or has a number 1,2,3,4,5,6,7,8,9 or 10 I need the formula to return the following results If H13 is blank return a blank cell If H13 is 1,2,3,4,5,6,7,8, or 9 return "SEE GE TOTALS" If H13 is 10 return "SEE SEDGWICK TOTALS" Thanks in advance of your help! =IF(H13="","",IF(OR(H13={1,2,3,4,5,6,7,8,9}),"SEE GE TOTALS","SE SEDGWICK TOTALS")) > I need help with the following problem. > Example [quoted text clipped - 5 lines] > > Thanks in advance of your help! Perfect, Thanks for the help!!! > =IF(H13="","",IF(OR(H13={1,2,3,4,5,6,7,8,9}),"SEE GE TOTALS","SE SEDGWICK > TOTALS")) [quoted text clipped - 8 lines] > > > > Thanks in advance of your help! You're welcome! > Perfect, Thanks for the help!!! > [quoted text clipped - 10 lines] > > > > > > Thanks in advance of your help! Perfect, Thanks for the help > =IF(H13="","",IF(OR(H13={1,2,3,4,5,6,7,8,9}),"SEE GE TOTALS","SE SEDGWICK > TOTALS")) [quoted text clipped - 8 lines] > > > > Thanks in advance of your help! try =IF(H3="","","See "& IF(H3>9,"Sedgwick","ge")& " totals")  SignatureDon Guillett Microsoft MVP Excel SalesAid Software dguillett1@austin.rr.com >I need help with the following problem. > Example [quoted text clipped - 5 lines] > > Thanks in advance of your help! |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.