Re: another formula question

From: Ken Wright (ken.wright_at_NOSPAMntlworld.com)
Date: 02/27/05 

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

If both need to be blank then:-

=IF(AND(A1="",B1=""),"",A1+B1)

but if there is no chance that only one cell will contain data then

=IF(A1="","",A1+B1) 

-- 
Regards
           Ken.......................    Microsoft MVP - Excel
              Sys Spec - Win XP Pro /  XL 97/00/02/03
----------------------------------------------------------------------------
                  It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------
"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: Surprise Execution meets Variation on Prisoners Dilemma
    ... let's surprise him by not posting on day 1. ... The cells are each large ... The jailer grabs two key rings [We'll assume for this that each key ... there's a 1-in-12 chance that B ...
    (rec.puzzles)
  • Re: What do you open with this 85 : - /AQJ104/-/KQJ98653
    ... The chance that it will make is actually closer to 5/9 not 4/9. ... Finally copy the row of five cells and paste them on the next 999 ... probability that partner holds one or both of them. ... and there are is the offsetting case where a heart ruff kills you at trick 1 ...
    (rec.games.bridge)
  • Surprise Execution meets Variation on Prisoners Dilemma
    ... a jailhouse in some small town in Kansas. ... The cells are each large ... out, however, the locked up thieves plead to be released so they to ... there's a 1-in-12 chance that B ...
    (rec.puzzles)
  • Re: HP and Functions
    ... What else is in those cells? ... doesn't make sense to excel? ... Any chance that you're getting a "formula too long" message? ... Mike S. wrote: ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Finding Duplicated Text within Columns
    ... While there is a chance this formula will not always be ... FALSE indicates that the cells of the same ... peach banana melon grape apple orange ... >I need to compare the columns and find which rows are ...
    (microsoft.public.excel.misc)