Function-formula help
 

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.

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.

"Robert M via OfficeKB.com" wrote:

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