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
|