Cell reads "Value" without an entry
 

d5 formula is =E5-14 (E5 is a date)

If there is no entry in d5 it reads "Value"

Is there a way for D5 to be just a white cell, without the "value"

Thank you
Mark

Cell reads "Value" without an entry
 

Your description is not quite clear
Maybe you meant to do this,
in D5: =IF(ISNUMBER(E5),E5-14,"")
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,000 Files:370 Subscribers:66
xdemechanik
---
"Mark" wrote:
d5 formula is =E5-14 (E5 is a date)
If there is no entry in d5 it reads "Value"
Is there a way for D5 to be just a white cell, without the "value"

Cell reads "Value" without an entry
 

E5 is a date

Try this:

=IF(N(E5),E5-14,"")

--
Biff
Microsoft Excel MVP


"Mark" wrote in message
...
d5 formula is =E5-14 (E5 is a date)

If there is no entry in d5 it reads "Value"

Is there a way for D5 to be just a white cell, without the "value"

Thank you
Mark

Cell reads "Value" without an entry
 

Dang you guys are good. I just wish there was a proper way to Thank you.

Thank you.

Mark

"Max" wrote:

Your description is not quite clear
Maybe you meant to do this,
in D5: =IF(ISNUMBER(E5),E5-14,"")
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,000 Files:370 Subscribers:66
xdemechanik
---
"Mark" wrote:
d5 formula is =E5-14 (E5 is a date)
If there is no entry in d5 it reads "Value"
Is there a way for D5 to be just a white cell, without the "value"

Cell reads "Value" without an entry
 

Yes this works. and it solves the last of my problems today. You experts are
diamonds in the rough. Thanks for helping us that struggle.

Mark

"T. Valko" wrote:

E5 is a date

Try this:

=IF(N(E5),E5-14,"")

--
Biff
Microsoft Excel MVP


"Mark" wrote in message
...
d5 formula is =E5-14 (E5 is a date)

If there is no entry in d5 it reads "Value"

Is there a way for D5 to be just a white cell, without the "value"

Thank you
Mark

Cell reads "Value" without an entry
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Mark" wrote in message
...
Yes this works. and it solves the last of my problems today. You experts
are
diamonds in the rough. Thanks for helping us that struggle.

Mark

"T. Valko" wrote:

E5 is a date

Try this:

=IF(N(E5),E5-14,"")

--
Biff
Microsoft Excel MVP


"Mark" wrote in message
...
d5 formula is =E5-14 (E5 is a date)

If there is no entry in d5 it reads "Value"

Is there a way for D5 to be just a white cell, without the "value"

Thank you
Mark

Cell reads "Value" without an entry
 

Welcome, Mark
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,000 Files:370 Subscribers:66
xdemechanik
---
"Mark" wrote in message
...
Dang you guys are good. I just wish there was a proper way to Thank you.