Formula help!

K

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
 
C

CLR

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

Vaya con Dios,
Chuck, CABGx3
 
J

JE McGimpsey

One way:

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

(I assume that F9 was a typo.)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top