another formula question

  • Thread starter Thread starter No
  • Start date Start date
N

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
 
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.
 
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)
 
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)
 
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'.
 
Back
Top