Thread: #N/A
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
sixthhole sixthhole is offline
external usenet poster
 
Posts: 6
Default #N/A

Is there anyway to return "0" when a cell receives the #N/A error? Not in
the same cell, but another one so it can be used in a new formula.

Ex: =IF(C81="#N/A", "0")

This didn't work.

Thanks for any help I can get.