Thread: Ignore #N/A in formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
sasquatch sasquatch is offline
external usenet poster
  
Posts: 6
Default Ignore #N/A in formula
I have a range of values that intentionally include #N/A (for charting
purposes). When I reference this range in a MIN or MAX formula, it returns
#N/A. How do I ignore the #N/A values in this range?
Reply With QuoteReply With Quote