another formula question

[No]

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

 

[Wild Jim]

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.

 

[Ken Wright]

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)

 

[Roger Govier]

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)

 

[Fester]

Option C:
=if(isblank(A1),"",A1+B1))

They all accomplish the same tasks.

Fester

 

[Fester]

Option C:

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

They all have the same result.

 

[Ken Wright]

Not necessarily, though admittedly likely in this case. If the cells in
question were 'blank' as a result of formulas returning "" because for
example a certain date hadn't been reached (or whatever), then ISBLANK will
not return what the OP is expecting, as the cells are not 'truly blank'.