Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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. |