Hey can someone help me!

[Guest]

My formula is not behaving properly. I'm looking for the lowest amount but
not zero. The formula is :

=IF(AND(J7<>0,J7<=H7,J7<E126),J7,IF(AND(H7<>0,H7<=J7,H7<E126),H7,E126))

Is there something that I'm missing? I tested the formula and I'm getting a
number that does not exist in any cell.

 

[Sandy Mann]

Thea,

Your formula can only return a value depending on the TUE/FALSE answers to
the IF's therefore it can only return the value in J7, H7 or E126. What
values do you have in all the referenced cells?

Regards

Sandy

 

[Guest]

Thea
Also have a look at how all the cells are formatted.
If any are text or scientific, you will get a strange answer.

HTH
Michael

 

[Don Guillett]

Hey is a lousy subject line. You get more answers with "how to get
minimum>0". Think of others later searching the archives for hey, can
someone help me.

Modify this to suit your needs and then ARRAY enter with ctrl+shift+enter
instead of just enter
=MIN(IF(H1:H10>0,H1:H10))