PPRuNe Forums - View Single Post - Setting up a spreadsheet to calculate mileage

1st Jan 2010, 18:02

#2 (permalink)

Rob82

Join Date: Nov 2005

Location: UK

Age: 41

Posts: 56

Likes: 0

Received 0 Likes on 0 Posts

Try something like

=IF(A1>10000,((A1-10000)*0.25)+4000,A1*0.4)

Where A1 is the cell with the total amout of miles.

May be an easier way to do it but that seems to work for me.

Rob

Reply