I am trying to figure out a formula for mileage. Anything under 22 miles is $25.30 and anything over 22 miles is multiplied by $1.50 plus $25.30. How do you create a formula for this?

=if(A1<=22;25.30;(A1-22)*1.5+25.30)

/Møller

Just for the fun

=((A1-22)*1.5)*(A1>22))+25.30

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

That's quite elegant. It's requires a bit more than basic understanding but is elegant. I think it might be faster too if there are a lot of calculations of the type.

/Møller

I don't know about faster, it's just a bit more " back to basics". No knowledge of functions needed

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post