Mileage tariffs for a taxi

You could also create a custom function to calculate the answer.

Function TARRIFF(mileage)
Select Case mileage
        Case Is < 0.5
            TARRIFF = 1
        Case 0.6 To 2
            TARRIFF = 0.8
        Case 2.1 To 5
            TARRIFF = 0.75
        Case Is > 5
            TARRIFF = 0.7
    End Select
End Function

Then in the cell you would type =TARRIFF(A1)