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

3	0	0
8	9	0
6	9	0
1	4	2
0	1	0

<tbody>
</tbody>

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