View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jd jd is offline
external usenet poster
 
Posts: 91
Default Lookup or Reference function ignoring errors

I am working on a spreadsheet with alot of lookup and reference functions. I
have gotten to pretty much my last step where i want to pull the lowest
number from a certain range of cells, but in both ranges there are error
values (#N/A).

When I use just the function:
=MIN(N7:N17)
(where N7:N17 is say #N/A,#N/A,#N/A, 16, 18, 20, 22)

it returns #N/A. Is there a way to ignore the errors and just get the
lowest number from that list (16).

Any help would be appreciated,
Thanks JD