Thread
:
Show zero in a cell
View Single Post
#
1
Posted to microsoft.public.excel.newusers
Clare
external usenet poster
Posts: 32
Show zero in a cell
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
Reply With Quote
Clare
View Public Profile
Find all posts by Clare