Showing a zero(if blank) when adding 3K to a cell

[mcr1]

IN cell F40, I have the # 3000, and it is permanently there.
In Cell d40, the cell is blank, but when the sheet is being used,
value is entered there and we'll say 1000 is what is typed in it.

I want to add the 2 cells (f40 and d40) and put the total of those
cells in C7. When I do that now, 3000 of course shows up and I woul
like for it (c7) to stay blank if nothing is in cell d40, the cell tha
stays blank until a # is added. I am having to do it like this in orde
to get around EXCEL not letting me put a value greater than 9999:59 i
case you were going to ask why I was doing it this way. I am addin
times. Any suggestions on how to make this happen? Thanks i
advance.

This is the formula I am putting in C7 and it still gives me 3000
=IF(F40="3000","",IF(F40=0,"",F40+D40))


Miles Ree

 

[RagDyeR]

Try this in C7:

=IF(D40,D40+F40,"")
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================



IN cell F40, I have the # 3000, and it is permanently there.
In Cell d40, the cell is blank, but when the sheet is being used, a
value is entered there and we'll say 1000 is what is typed in it.

I want to add the 2 cells (f40 and d40) and put the total of those 2
cells in C7. When I do that now, 3000 of course shows up and I would
like for it (c7) to stay blank if nothing is in cell d40, the cell that
stays blank until a # is added. I am having to do it like this in order
to get around EXCEL not letting me put a value greater than 9999:59 in
case you were going to ask why I was doing it this way. I am adding
times. Any suggestions on how to make this happen? Thanks in
advance.

This is the formula I am putting in C7 and it still gives me 3000
=IF(F40="3000","",IF(F40=0,"",F40+D40))


Miles Reed

 

[Guest]

Hi
if I understood you correctly this can't be achieved with formulas alone.
You may have a look at:
http://www.mcgimpsey.com/excel/accumulator.html