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.

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

--
to e-mail direct replace @mailinator.com with @tiscali.co.uk


"Thea" wrote in message
...
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.

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

"Thea" wrote:

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.

Hey is a lousy subject line. You get more answers with "how to get
minimum0". 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:H100,H1:H10))

--
Don Guillett
SalesAid Software

"Thea" wrote in message
...
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.