PPRuNe Forums - View Single Post - Log book on a spread sheet
View Single Post
Old 8th September 2014 | 13:42
  #4 (permalink)  
stickandrudderman
15 Anniversary
 
Joined: Aug 2006
Posts: 927
Likes: 1
From: Sth Bucks UK
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  
Reply