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"))
Page 1 / 1
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!
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.