| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Formula help!
Hi
I'm need a formula in cell C9 that does the following: If D9 is blank then C9 is blank If D9 is not blank and F9 is blank then I need C9 to display a message "You must enter a number is E9" If D9 is not blank and E9 is not blank, then C9 is blank. Any help is greatly appreciated!! Thanks in advance Kimberly |
|
#2
|
|||
|
|||
|
=IF(D9="","",IF(E9="","You must enter a number is E9",""))
Vaya con Dios, Chuck, CABGx3 "KimberlyC" wrote in message ... Hi I'm need a formula in cell C9 that does the following: If D9 is blank then C9 is blank If D9 is not blank and F9 is blank then I need C9 to display a message "You must enter a number is E9" If D9 is not blank and E9 is not blank, then C9 is blank. Any help is greatly appreciated!! Thanks in advance Kimberly |
|
#3
|
|||
|
|||
|
One way:
=IF(D9="","",IF(E9="","You must enter a number in E9","")) (I assume that F9 was a typo.) In article , "KimberlyC" wrote: Hi I'm need a formula in cell C9 that does the following: If D9 is blank then C9 is blank If D9 is not blank and F9 is blank then I need C9 to display a message "You must enter a number is E9" If D9 is not blank and E9 is not blank, then C9 is blank. Any help is greatly appreciated!! Thanks in advance Kimberly |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| referencing named formula using INDIRECT function | Excel Worksheet Functions | |||
| Simplify formula | Excel Worksheet Functions | |||
| put formula results into a different cell if it is empty | Excel Worksheet Functions | |||
| how do i write a formula and keep in in formula form, so it DOESN. | Excel Discussion (Misc queries) | |||
| Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Linear Mode
