Formula
 

Excel 2003

Question:
How to write an if then formula to take the "0" out of the linked pages in
the spreadsheet?

Can anyone help me with this?

Thank you.

Robert M via OfficeKB.com wrote:
How to write an if then formula to take the "0" out of the linked pages in
the spreadsheet?


I assume you mean that you have linking formulas which are referencing empty
cells and showing as 0 and you would prefer them to look empty.

One simple way is Tools / Options / View / uncheck Zero Values
which is OK if there are no valid 0 values in the data.

Otherwise if the formula is currently =X, change it to
=IF(ISBLANK(X),"",X)

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup