Thread: Removing #N/A from an "If/Then" statement
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Collin Ulvund Collin Ulvund is offline
external usenet poster
  
Posts: 2
Default Removing #N/A from an "If/Then" statement
I'm doing some report making for my job, and pieced together this formula:

=IF(D9=0,NA(),D9) with base formula of =IF(hostcell=0,NA(),hostcell)

The formula has worked wonderfully, but it leaves "#N/A" in the cell and my supervisor would like to not see anything within the table, as they are being included in this report.

Does anyone know how this could be achieved?
Reply With QuoteReply With Quote