software

Hello,

I am trying to write a formula on a spreadsheet on a column of cells,
but I don't want the values of the formula to show up in the cells that
haven't had data entered into them...for instance, when I enter the
values in a cell, every cell in the column has the same value as the
cell above it..I want those cells below to be BLANK until I enter the
corresponding data..Hope I explained it good enough..PLEASE HELP

Max

P.S. the formula I have in all the cells in the column is:

=SUM((D4, E5),SUM(-C5))--
Max3659
------------------------------------------------------------------------
Max3659's Profile: www.excelforum.com/member.php...oamp;userid=31936
View this thread: www.excelforum.com/showthread...hreadid=516606Hi!

It depends on which cell or cells you want to use as the quot;keyquot;.

For example:

If D4 is blank the formula cell will remain blank

=IF(D4=quot;quot;,quot;quot;,SUM(D4,E5,-C5))

If ALL 3 cells are blank the formula cell remains blank:

=IF(COUNT(D4,E5,C5)lt;3,quot;quot;,SUM(D4,E5,-C5))

If EITHER D4 or E5 are blank then the formula cell will remain blank:

=IF(OR(D4=quot;quot;,E5=quot;quot;),quot;quot;,SUM(D4,E5,-C5))

So, there are many ways to do this.

Biff

quot;Max3659quot; gt; wrote in
message ...
gt;
gt; Hello,
gt;
gt; I am trying to write a formula on a spreadsheet on a column of cells,
gt; but I don't want the values of the formula to show up in the cells that
gt; haven't had data entered into them...for instance, when I enter the
gt; values in a cell, every cell in the column has the same value as the
gt; cell above it..I want those cells below to be BLANK until I enter the
gt; corresponding data..Hope I explained it good enough..PLEASE HELP
gt;
gt; Max
gt;
gt; P.S. the formula I have in all the cells in the column is:
gt;
gt; =SUM((D4, E5),SUM(-C5))
gt;
gt;
gt; --
gt; Max3659
gt; ------------------------------------------------------------------------
gt; Max3659's Profile:
gt; www.excelforum.com/member.php...oamp;userid=31936
gt; View this thread: www.excelforum.com/showthread...hreadid=516606
gt;

First of all..Thank you for trying to help..I must not have explained my
problem correctly because your options didn't work...you seem very
intelligent with excel...do you think I could send u a copy of my
program and have you look at it?--
Max3659
------------------------------------------------------------------------
Max3659's Profile: www.excelforum.com/member.php...oamp;userid=31936
View this thread: www.excelforum.com/showthread...hreadid=516606I see you're posting through ExcelForum. You can upload files at that site.
You can zip the file and post it and I (or someone) will take a look. I
won't be able to get to it tonight, however. It's almost 3:00 AM where I am
and I'm about to call it a night!

Biff

quot;Max3659quot; gt; wrote in
message ...
gt;
gt; First of all..Thank you for trying to help..I must not have explained my
gt; problem correctly because your options didn't work...you seem very
gt; intelligent with excel...do you think I could send u a copy of my
gt; program and have you look at it?
gt;
gt;
gt; --
gt; Max3659
gt; ------------------------------------------------------------------------
gt; Max3659's Profile:
gt; www.excelforum.com/member.php...oamp;userid=31936
gt; View this thread: www.excelforum.com/showthread...hreadid=516606
gt;