Function-formula help

  • Thread starter Robert M via OfficeKB.com
  • Start date
R

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.
 
D

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.
 
Top