Re: Cell reads "Value" without an entry
- From: Mark <Mark@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 5 Feb 2009 18:19:01 -0800
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" <Mark@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:02FB3D17-F4DE-41B1-A227-D952EB7BD087@xxxxxxxxxxxxxxxx
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
- Follow-Ups:
- Re: Cell reads "Value" without an entry
- From: T. Valko
- Re: Cell reads "Value" without an entry
- References:
- Cell reads "Value" without an entry
- From: Mark
- Re: Cell reads "Value" without an entry
- From: T. Valko
- Cell reads "Value" without an entry
- Prev by Date: Re: Cell reads "Value" without an entry
- Next by Date: Re: Cell reads "Value" without an entry
- Previous by thread: Re: Cell reads "Value" without an entry
- Next by thread: Re: Cell reads "Value" without an entry
- Index(es):
Relevant Pages
|
