Help

Re: Nested Formulas

791 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Erica_Holleran
5 - Automation Enthusiast
5 - Automation Enthusiast

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.

Erica_Holleran
5 - Automation Enthusiast
5 - Automation Enthusiast

Bill - thank you so much, that did it!