| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula 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! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula help
=IF(H13="","",IF(OR(H13={1,2,3,4,5,6,7,8,9}),"SEE GE TOTALS","SE SEDGWICK
TOTALS")) "danlinksman" wrote: 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! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula help
try
=IF(H3="","","See "& IF(H39,"Sedgwick","ge")& " totals") -- Don Guillett Microsoft MVP Excel SalesAid Software "danlinksman" wrote in message ... 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! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula help
Perfect, Thanks for the help!!!
"Teethless mama" wrote: =IF(H13="","",IF(OR(H13={1,2,3,4,5,6,7,8,9}),"SEE GE TOTALS","SE SEDGWICK TOTALS")) "danlinksman" wrote: 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! |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula help
Perfect,
Thanks for the help "Teethless mama" wrote: =IF(H13="","",IF(OR(H13={1,2,3,4,5,6,7,8,9}),"SEE GE TOTALS","SE SEDGWICK TOTALS")) "danlinksman" wrote: 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! |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula help
You're welcome!
"danlinksman" wrote: Perfect, Thanks for the help!!! "Teethless mama" wrote: =IF(H13="","",IF(OR(H13={1,2,3,4,5,6,7,8,9}),"SEE GE TOTALS","SE SEDGWICK TOTALS")) "danlinksman" wrote: 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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
