Hi there.

I'm new to excel and trying to learn.

I need to work out a way to give prices where:

A journey is 10 dollars for the first 2 miles, then 2.50 for miles 3-25, then 2.20 for miles 26-50, then 1.60 for miles 51-100 and lastly 1.10 for miles from 101 to infinity.

How would I begin to approach such a formula within excel?

Thanks