PPRuNe Forums - View Single Post - Log book on a spread sheet

8th September 2014 | 20:59

#5 (permalink)

Old Speckled Aircrew

Joined: Jan 2006

Posts: 42

Likes: 2

From: Fairford, Gloucestershire, England

To make K & J columns cumulative just add the previous value to your if statement.

Leave line 2 blank and in K3:
=IF(D3="P1",J3,0)+K2

and in L3
=IF(D3="P2",J3,0)+L2

Then fill down

Reply

0