View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JRForm JRForm is offline
external usenet poster
 
Posts: 130
Default min value not zero

I am looking for a way to evaluate three columns of values to find the one
that is the minimum and not zero. for example:
ColA colB ColC
2.5 3.2 0

The formula should return 2.5.

Any help would be appreciated.

JRForm.