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

2nd January 2010 | 06:13

#5 (permalink)

MetoPower

Joined: Aug 2007

: ATPL

Posts: 57

Likes: 1

From: The World

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 January 2010 at 07:00.

Reply