Help

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

899 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!