View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
widman
 
Posts: n/a
Default To show "0" instead of #N/A

If cel C1 is A1-B1, how can I get C1 to show 0 if one of A1 or B1 is #N/A
instead of C1 ending up also #N/A?