Thread: [Solved] How to create mileage formula
View Single Post
 
Old 08-14-2016, 10:43 PM
c991257 c991257 is offline Windows 10 Office 2016
Advanced Beginner
  
Join Date: Mar 2014
Location: Zambia
Posts: 61
c991257 is on a distinguished road
Default
Quote:
Originally Posted by maxliv View Post
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
Reply With Quote