Hiding the results of a formula generated from a blank cell

G

Guest

Hi there,
I've very helpfully had my question regarding how to add 4 days onto a date
using a formula answered. However having set up the formula and dragged it
down the sheet the cells where the reference cell is blank are giving the
date 4-Jan-00. I understand that it must be thinking that the blank cell
represents 31-12-99 or 0 in time but I don't want that to show. How can I
hide those results? I suppose I need an if clause or somesuch?
What do you think?
Cheers,
Will
 
R

Roger Govier

Hi Will

Yes a blank cell is interpreted by Excel as 00/01/1900 or 31/12/1899 and
that is exactly why you are seeing those dates.
Try
=IF(A1="","",A1+4)
 
G

Guest

Hi Roger,
That's perfect. Thanks.
Will

Roger Govier said:
Hi Will

Yes a blank cell is interpreted by Excel as 00/01/1900 or 31/12/1899 and
that is exactly why you are seeing those dates.
Try
=IF(A1="","",A1+4)
Click to expand...
 
G

Gord Dibben

Go back to your original post for answer to this question.


Gord Dibben MS Excel MVP
 

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

Blank 3
How To Have A Cell Be Blank If... 2
Sorting blank cells with a formula in them 1
formula error 1
auto hide blank rows 1
Need Array Formula for Counting Blank & Non Blank Cells (Multiple Criteria) 1
Displaying results in formula bar when cell is hidden 1
Is that possible. More than on If Formula 2

Top