Re: another formula question

From: Roger Govier (roger_at_technologyNOSPAM4u.co.uk)
Date: 02/27/05 

Date: Sun, 27 Feb 2005 11:24:41 -0000

Hi

Two suggestions
1. Go to Tools=>Options=>View and deselect Show Zero values
or
2. Wrap your formula in an IF statement
=IF(A1+B1=0,"",A1+B1) 

-- 
Regards
Roger Govier
"No" <no@isp.com> wrote in message 
news:1123apvnlka5m33@corp.supernews.com...
>I know how to do a basic formula that adds 2 cells but when I drag that
> formula down to copy it to other cells where there is no total due to no
> data entered yet it shows $0.00.
>
>  besides +A1+B1    is there anything else that I can add to the formula 
> so
> that the cell is blank untill there is a total to display, in other words,
> get rid of the $0.00 in all the cells
>
>

Relevant Pages

  • Re: Complex if
    ... all of the conditions are either empty, have text, or have the numerical value zero. ... it suggests that those cells that meet the conditions contain zero -- assuming that #2 and #3 return exactly zero. ... IF('Enroll I'!$K$2:$K$2921>0, Enroll I'!$L$2:$L$2921))))))) ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Sumif Fails w Date as Text
    ... Yes, I misread your posting. ... In any case I tried switching it and still get zero. ... "Roger Govier" wrote: ... Then I have a set of cells that calculates the first of the ...
    (microsoft.public.excel.misc)
  • RE: Find same value in continuous Cells
    ... I double checked my cells. ... The first zero value in this sheet occurs at E81 ... Dim Lastrow As Integer 'Last Row of Printing Range ...
    (microsoft.public.excel.programming)
  • RE: carry down total
    ... Now how do I get it not to reset to total to zero but be able to carry it to ... cruchnin numbers ... "Joel" wrote: ... tow cells inside the ANDare cells that contain the TRUE ...
    (microsoft.public.excel.misc)
  • RE: Find same value in continuous Cells
    ... I;ve been stepping through it and it looks like it is counting the cells ... with values other that zero but I don't know how to reverse it. ... Dim Lastrow As Integer 'Last Row of Printing Range ...
    (microsoft.public.excel.programming)
Loading