help with a cell displaying data...

  • Thread starter Thread starter Matthew
  • Start date Start date
M

Matthew

If I have a cell with a basic formula =d3+d5, how do I get the cell to
remain blank if one of the two referenced cells has no data?

And does anyone have any tutorial links handy?
 
Hi Matthew,

Am Tue, 3 Aug 2010 09:12:14 -0400 schrieb Matthew:
If I have a cell with a basic formula =d3+d5, how do I get the cell to
remain blank if one of the two referenced cells has no data?

=IF(COUNT(D3,D5)<2,"",D3+D5)


Regards
Claus Busch
 
Matthew said:
If I have a cell with a basic formula =d3+d5, how do I get the cell to
remain blank if one of the two referenced cells has no data?

And does anyone have any tutorial links handy?

=if(or(d3="",d5=""),"",d3+d5)

F1 for tutorial.
 
One more quick question... I used that exact formula throughout a
spreadsheet and everything worked just fine but when I opened up the same
spreadsheet today and added new columns excel flags the formula as having
problems. I did properly adjust the formula for the new cells and I've
compaired it to the formula in the next cell over and everything is the
same.
 
One more quick question... I used that exact formula throughout a
spreadsheet and everything worked just fine but when I opened up the same
spreadsheet today and added new columns excel flags the formula as having
problems. I did properly adjust the formula for the new cells and I've
compaired it to the formula in the next cell over and everything is the
same.

Ignore Excel flags. They are usually misleading. In fact, I disable
them. In Excel 2003, click Tools > Options > Error Checking, and
deselect Enable Background Error Checking. Then click Reset Ignored
Errors.
 
Back
Top