Nested Formulas

[Erica_Holleran]

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"))

[BillH]

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

[Erica_Holleran]

Bill - thank you so much, that did it!