Jennlax27iga0
New Member
- Joined
- May 4, 2011
- Messages
- 21
Hello, I am trying to use the following formula:
=IF(E31<=E27, J27,IF(E31>E29, $J$29, IF(E31=E28, $J$28, IF(E28>E31>E27, ((E31-E27)/(E28-E27))*$J$28, IF(E29>E31>E28, ((E31-E28)/(E29-E28)*($J$29-$J$28))+$J$28, "")))))
It works except for those values that fall in between two numbers, in this case either when E28>E31>E27 or E29>E31>E28. In those cases the formula only works if the range the number falls in is listed first in the formula. For example in the formula above, if E29>E31>E28, it does not calculate correctly and I have to rearrange the formula such that the portion with E29>E31>E28 is listed before the portion with E28>E31>E27, and then it works. However if E28>E31>E27 in the formula above, it works.
Why am I having this issue, and what can I do to correct it? Thanks!
=IF(E31<=E27, J27,IF(E31>E29, $J$29, IF(E31=E28, $J$28, IF(E28>E31>E27, ((E31-E27)/(E28-E27))*$J$28, IF(E29>E31>E28, ((E31-E28)/(E29-E28)*($J$29-$J$28))+$J$28, "")))))
It works except for those values that fall in between two numbers, in this case either when E28>E31>E27 or E29>E31>E28. In those cases the formula only works if the range the number falls in is listed first in the formula. For example in the formula above, if E29>E31>E28, it does not calculate correctly and I have to rearrange the formula such that the portion with E29>E31>E28 is listed before the portion with E28>E31>E27, and then it works. However if E28>E31>E27 in the formula above, it works.
Why am I having this issue, and what can I do to correct it? Thanks!