Show zero in a cell

[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

 

[Eduardo]

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)

 

[NBVC]

Try:

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

 

[NBVC]

SUM() is redundant...in this formula

 

[Max]

You could use something like this:
=IF(H3="","",SUM(TODAY()-H3)/7)

p/s: Use TODAY, not NOW to get the difference in days between 2 dates
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik

 

[Scoops]

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 Clare

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

Regards

Steve

 

[Max]

Oops, the SUM is extraneous
Just this:
=IF(H3="","",(TODAY()-H3)/7)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---

 

[Clare]

Thanks this site is fantastic

Cheers

 

[Max]

Thanks this site is fantastic

You're welcome. Do take a moment to click the YES button in each response in
this thread which helped you.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---

 

[Shane Devenshire]

And a slightly shorter one

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

 

[Shane Devenshire]

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.