Y
yshridhar
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
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