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

2nd Jan 2010, 06:13

#5 (permalink)

MetoPower

Join Date: Aug 2007

Location: The World

Posts: 55

Likes: 0

Received 0 Likes on 0 Posts

In A1 insert the distance, then in B1:
=A1*(IF(A1<=10000,0.4,0)+IF(A1>10000,0.25,0))
Then format cell and select currency.

MP

Last edited by MetoPower; 2nd Jan 2010 at 07:00.

Reply