Find last available and check upwards to find minimum requerements

[dado6612]

haha posted this one by accident.. editing in progress..

 

[dado6612]

Got logged out while editing..

Hello everyone,

Hope I can make sense out of this one, might be easy one

[TABLE="class: grid, width: 200, align: center"]
<tbody>[TR]
[TD="align: center"]3[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[/TR]
[TR]
[TD="align: center"]8[/TD]
[TD="align: center"]9[/TD]
[TD="align: center"]0[/TD]
[/TR]
[TR]
[TD="align: center"]6[/TD]
[TD="align: center"]9[/TD]
[TD="align: center"]0[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]2[/TD]
[/TR]
[TR]
[TD="align: center"]0[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]0[/TD]
[/TR]
</tbody>[/TABLE]
In column A I have series of number, and starting in B2 is formula =A2+INT(B1/3), merging previous value divided by 3 and value in the same row
What I would like to have, either in column C or fitted in column B are minimal requirements I need to merge for the last value of 1 or more..
As given example in table..
Detalied explanation of column C

C5 - last value of 1, need 0 more because merging previous values can achieve at least one in here (and also new value of C5 is not 3 and can't form 1 in C6)
C4 - have 1, need 2 more to merge
C3 - have 6, need 0 to merge
C2 - not needed since bottom rows fulfill requirements
C1 - not needed since bottom rows fulfill requirements

Thank you

 

[dado6612]

Since there is still no reply, and I had no luck for past 4 days on my own, will try to bump this thread..

 

[dado6612]

Alright, got it.. In a way, Some IFs did a trick