View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Melanie Melanie is offline
external usenet poster
 
Posts: 78
Default if statement? Want to populate whats in cell or N/A if cell is zer

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!