Re: Blank or Zero in cell required

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance


> > A B C
> > 1 1 10 10
> > 2 2 12 22
> > 3 3 15 37
> > 4 4 0 37
> > 5 5 0 37
> > 6 6 0 37
> >
> > Hi
> >
> > I hope I can explain this sufficiently well. Column A is week numbers
> > (1-52), column B is points gained that week, column C is the cumulative
> > total of points. So far so good...the problem is I would like the
> remaining
> > cells in column C to be blank or contain a zero until that week is in
> play.
> > However, when I copy the formula down the value from the last week
> populates
> > the remaining weeks. Below if the formula I'm using, this would be in
C3.
> I
> > realise if I get rid of the +C2 bit it would work but then we don't have
a
> > running total of points gained.
> >
> >
> >
> > =SUMIF(E35,">=0",E35)+C2
> >

> Try this:
>
> =if(e35>=0,e35+c2,"")
> *******************
> ~Anne Troy
>
> www.OfficeArticles.com
>

Hi - thanks, but =if(e35>=0,e35+c2,"") produces the same result :-(


.

Relevant Pages

  • Blank or Zero in cell required
    ... cells in column C to be blank or contain a zero until that week is in play. ... when I copy the formula down the value from the last week populates ... realise if I get rid of the +C2 bit it would work but then we don't have a ... Prev by Date: ...
    (microsoft.public.excel.newusers)
  • Re: Blank or Zero in cell required
    ... ~Anne Troy ... > realise if I get rid of the +C2 bit it would work but then we don't have a ... Prev by Date: ...
    (microsoft.public.excel.newusers)
  • Re: how to remove horizontal lines
    ... Anne Troy ... and now I want to get rid of them. ... > Michael Eisenstadt ... Prev by Date: ...
    (microsoft.public.word.newusers)
  • Re: Blank or Zero in cell required
    ... "News Account" wrote: ... >> ~Anne Troy ... Prev by Date: ...
    (microsoft.public.excel.newusers)
  • Re: No Blank Document When Opening Word 2000
    ... Anne Troy ... > One of my work colleagues can't get rid of a MS Word 2000 problem. ... but I don't know the procedure to fix it. ...
    (microsoft.public.word.application.errors)