Microsoft Office Forums - View Single Post - [Solved] How to create mileage formula

Thread: [Solved] How to create mileage formula

View Single Post

Old

08-14-2016, 03:13 PM

maxliv

maxliv is offline

maxliv uses Windows 10

Windows 10 maxliv uses Office 2016

maxliv uses Office 2016

Office 2016

Novice

The original poster

Join Date: Aug 2016

Posts: 1

maxliv is on a distinguished road

Smile

How to create mileage formula

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?

Reply With Quote