Nested IF statement failing

[CelestialMech]

I’m trying to created a curve that defines a limit as an imported value in column A increases.
It works for the first two conditions, a plateau of 5 alongside values up to 51, and a smooth slope from 5 to 14 between 51 and 10499, but then instead of a new plateau of 14 from then on the slope continues. So the 14 at the end there seems to be being ignored by the second IF nest, I suspect I’m missing something simple in the brackets or the formating, but I’ve tried numerous options to no avail.
Any ideas?

IF(A20<51,5,(IF(51<A20<10499,(5+(((A20-51)/10449)*9)),14)))

[Edit - Opaque]] Made formula preformatted text to make it readable

[anon73440385]

Hello,

replace 51<A20<10499 by AND(A20>51;A20<10499) and it should work (though I wonder myself why 51<A20<10499 isn’t throwing an error and always evaluates to TRUE)

PS: From a mathematical point of view your function has a discontinuity at 51

Hope that helps.

If the answer is correct or helped you to solve your problem, please click the check mark () next to the answer.

[mikekaganski]

I wonder myself why 51<A20<10499 isn’t throwing an error and always evaluates to TRUE

It is evaluating from left to right: (51<A20)<10499→TRUE<10499→1<10499→TRUE

[anon73440385]

@mikekaganski - Thanks for the explanation, my comment in parentheses worked like a charm

[CelestialMech]

Sorted, thanks!