Re: another formula question

From: Wild Jim (nigel_at_nbbriggs2004.screaming.net)
Date: 02/27/05 

Date: Sun, 27 Feb 2005 11:23:56 -0000

Try using an =if formula

so instead of +A1+B1, use: =if(A1+B1<>0,A1+B1,"")

in this formula, the if statement checks whether A1+B1 is not equal to zero.
If it isn't, it puts in the value A1+B1, if it does equal zero, it puts in a
blank space ie "".

Hope that helps.

"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: two problems with excel 2003
    ... Try Tools, Options, Error Checking and uncheck Formula Omits Cells in Region, ... > formula or function used is dividing by zero or empty cells." ... > way to get rid of this message and just see a blank cell or perhaps a Zero ...
    (microsoft.public.excel.misc)
  • two problems with excel 2003
    ... the data used by the formulas are now empty. ... The cells containing the formulas now display #DIV/0! ... way to get rid of this message and just see a blank cell or perhaps a Zero ...
    (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)