Show zero in a cell

  • Thread starter Thread starter Clare
  • Start date Start date
C

Clare

Hi

I have the undernoted formula, however, when cell H3 has no date in it the
cell with the formula shows 5714 can anyone tell me how to make the cell show
0 when there is no date in cell H3.

=SUM(NOW()-H3)/7

Thanks
 
Hi,

=if(H3="","",=SUM(NOW()-H3)/7)

the formula above will leave the cell blank if you want to have 0 use

=if(H3="",0,=SUM(NOW()-H3)/7)
 
Hi

I have the undernoted formula, however, when cell H3 has no date in it the
cell with the formula shows 5714 can anyone tell me how to make the cell show
0 when there is no date in cell H3.

=SUM(NOW()-H3)/7

Thanks
Click to expand...

Hi Clare

=IF(H3="",0,SUM(NOW()-H3)/7)

Regards

Steve
 
Just a suggestion,

If you give a Yes to a later answer, that is the same as an earlier answer,
you should go back and click yes for each of those early "correct" answers.
Its just to be fair to Max, Eduardo, or NBVC, since the Microsoft site tracks
the number of answered questions based on this, they never actually look at
each question and answer, they rely on the user feedback.
 
Back
Top