Skip to main content

Nested Formulas

  • July 27, 2023
  • 2 replies
  • 12 views

Forum|alt.badge.img+3

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

BillH
Forum|alt.badge.img+24
  • Brainy
  • July 27, 2023

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


Forum|alt.badge.img+3
  • Author
  • New Participant
  • July 27, 2023

Bill - thank you so much, that did it!