Min function excluding zero

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
 
T

T. Valko

Try one of these for the MIN:

=SMALL(A1:A10,1+COUNTIF(A1:A10,0))

Or this array formula**:

=MIN(IF(A1:A10>0,A1:A10))

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)
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

Try it like this:

=IF(OR(A1={1,2}),"A","B")
 
P

Phillip Quade

Mr. Biff,
My question may not pertain to this formula, but your responses to other questions are awesome.

My question is complex for me. I want to look through column B and find the values less than a value input in a cell F22. Then look through column C to find values greater than input in cell F22. Then look through column F find a value greater than a value calculated in cell F23. Then look through column G find the value less than a value calculated in cell F23. Through this it will lead to one specific row.
 
P

Pete_UK

Biff seems to have stopped posting in the newsgroups now, though he is
still a regular on the MS Forums.

I'm not sure what it is that you want to do. Are you looking for 4
different numbers? Please describe your problem with reference to a
few examples.

Hope this helps.

Pete
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top