Function-formula help

[Robert M via OfficeKB.com]

Excel 2003

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

Can anyone help me with this?

Thank you.

 

[Dave Peterson]

Do you mean you have a formula like:
=sheet2!a1
that returns 0 when A1 on sheet2 is empty?

if yes:
=if(sheet2!a1="","",sheet2!a1)

should work.