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

1st January 2010 | 18:02

#2 (permalink)

Rob82

Joined: Nov 2005

Posts: 56

Likes: 0

From: UK

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

0