|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
|
Thread Tools | Display Modes |
|
#1
July 6th, 2009, 04:15 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
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 
|
|
#2
July 6th, 2009, 04:21 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Show zero in a cell
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) "Clare" wrote: 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
|
|
#3
July 6th, 2009, 04:24 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Show zero in a cell
Try: =IF(H3="",0,(NOW()-H3)/7) -- NBVC Where there is a will there are many ways. 'The Code Cage' (http;//www.thecodecage.com) ------------------------------------------------------------------------ NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=112967
|
|
#4
July 6th, 2009, 04:30 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Show zero in a cell
SUM() is redundant...in this formula -- NBVC Where there is a will there are many ways. 'The Code Cage' (http;//www.thecodecage.com) ------------------------------------------------------------------------ NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=112967
|
|
#5
July 6th, 2009, 04:31 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Show zero in a cell
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 --- "Clare" wrote: 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
|
|
#6
July 6th, 2009, 04:32 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Show zero in a cell
On 6 July, 16:15, Clare wrote:
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
|
|
#7
July 6th, 2009, 04:34 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Show zero in a cell
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 ---
|
|
#8
July 6th, 2009, 04:40 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Show zero in a cell
Thanks this site is fantastic
Cheers -- Clare "Max" wrote: 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 ---
|
|
#9
July 7th, 2009, 12:26 AM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Show zero in a cell
"Clare" wrote:
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 ---
|
|
#10
July 7th, 2009, 12:58 AM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Show zero in a cell
And a slightly shorter one
=IF(H3,(NOW()-H3)/7,0) -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Clare" wrote: 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
|
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
