help with a cell displaying data...

[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?

 

[Claus Busch]

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]

Hi Matthew,

Am Tue, 3 Aug 2010 09:12:14 -0400 schrieb Matthew:


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


Regards
Claus Busch
--

Thanks!

 

[Jordon]

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.

 

[Matthew]

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.

 

[joeu2004]

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.