View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
yshridhar yshridhar is offline
external usenet poster
 
Posts: 229
Default Min function excluding zero

hi, i have a set of positive numbers (randomly generated) which includes a
zero . I want to pickout the Min from them which excludes zero. i.e, Min
greater than zero.

My second question is
=if(or(a1=1,a1=2),"A","B")) I modified it to
=if(a1={1,2},"A","B"). But This formula is true only for a1=1
any suggestions.
Thank you all
With regards
Sridhar