How To Have A Cell Be Blank If...

  • Thread starter Thread starter Bob
  • Start date Start date
B

Bob

Hello,

Using Excel 2007.
Not too sharp with this, so please bear with me a bit.
Will try and explain what I would like to do as clearly as possible,
hopefully.

I have a multitude of rows that start with a date, then some cells with
data, and then the final cell, in each row, with the result of a simple
calculation on the data in the row.

This works fine.

But I would like, for the final cell (the one that has the calculation
result, usually) to show as a blank, unless the starting cell in its row
actually has a date there.

The final cell calculation for the first row, in E1 is simply, e.g.,
=(B1+C1+D1)
with the Date being in A1

I drag E1 downward to fill up the next 100 rows with the formula.

How do I simply do this please to have the E cells be blank if there is
no date for it's A cell ?

Thanks,
Bob
 
I have a multitude of rows that start with a date, then some cells with
data, and then the final cell, in each row, with the result of a simple
calculation on the data in the row.

This works fine.

But I would like, for the final cell (the one that has the calculation
result, usually) to show as a blank, unless the starting cell in its row
actually has a date there.


The final cell calculation for the first row, in E1 is simply, e.g.,
=(B1+C1+D1)
with the Date being in A1
Click to expand...

When A1 is not a date, what might it be?
(a) empty?
(b) a text value?
(c) a numerical value?
(d) could be any of the above?
The reason for asking is that behind the scenes in Excel, a date value is really just a number, formatted differently. So if (c) cannot happen, then something like this might help:
=IF(ISNUMBER(A1),B1+C1+D1,"")

Otherwise, the problem gets harder.
 
Hi,

Thanks for help; much appreciated.

If A1 is not a date, then the Cell is empty.

Thanks again,
Bob
----------------------------------------------------------------------
 
Back
Top