Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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" |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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" |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula to confirm entry in Col "C" is valid for data in Col "A" | Excel Discussion (Misc queries) | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
How do I Make a "IF" formula where it reads between 2 sets of numb | Excel Discussion (Misc queries) | |||
When I input "25:03" as a time, it reads "1:03" | Excel Discussion (Misc queries) | |||
Is there a formula thet reads (If A2=A1,"",INSERT PAGE BREAK) ? | Excel Discussion (Misc queries) |