Formula help!

[KimberlyC]

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

 

[CLR]

=IF(D9="","",IF(E9="","You must enter a number is E9",""))

Vaya con Dios,
Chuck, CABGx3

 

[JE McGimpsey]

One way:

=IF(D9="","",IF(E9="","You must enter a number in E9",""))

(I assume that F9 was a typo.)