The Community will be undergoing maintenance on Friday January 10 at 2:00pm - Saturday January 11 at 2:00pm EST, and will be "read-only." For assistance during this time, please visit our Help Center.

Re: Nested Formulas

posted Jul 27, 2023 9:25:53 AM

0 824 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!