PPRuNe Forums - View Single Post - Log book on a spread sheet
View Single Post
Old 8th Sep 2014, 13:42
  #4 (permalink)  
stickandrudderman
 
Join Date: Aug 2006
Location: Sth Bucks UK
Age: 60
Posts: 927
Likes: 0
Received 0 Likes on 0 Posts
Some results:


To get the "P1" or "P2" to be the determinate factor I ended up with this:


=IF(D4=ʺP1ʺ,K3+J4,)


and in the next column:


=IF(D4=ʺP2ʺ,L2+J4,)


My deduction is that the last comma before the close bracket leaves the cell blank. If I used the "0" as in Keef's example above the I would get "0" in that cell.
stickandrudderman is offline