Melanie,

You don't give much detail but this may point you in the right direction:-

=IF(Sheet2!A1<0,Sheet2!A1,"N/A")

Mike

"Melanie" wrote:

Hi, I need to pull a value from one sheet to another. I want the value to
populate in a new worksheet as is, but if the value is zero i need it to read
N/A.

How can I do this? an If statement?

Thank you!