The Community will be undergoing maintenance from Friday February 21 - Friday, February 28 and will be "read only" during this time. To learn more, check out our Announcements blog post.

Re: Nested Formulas

posted Jul 27, 2023 9:25:53 AM

0 899 0

Can someone help me with this - it is not calculating if over 99 only if over 49

IF({Miles}>49,"0.10", IF({Miles}>99,"0.15"))

2 Replies 2

Try reversing the order - 100 would be over 49, so it would never get to the second step.

Bill - thank you so much, that did it!