Improvement....

On Nov 16, 9:02 am, I wrote:
Alternatively, the formula in H2 could be:

=if(A2="", "", min(round(A2*0.8%, 2), 56))

and the formula starting in H3 (and copy down) could be:

=if(A3="", "",
min(round(A3*0.8%, 2), max(0, 56-round(sum($A$2:A2)*0.8%, 2))))

Silly me! The second formula can simply be:

=IF(A3="", "", min(round(A3*0.8%,2), max(0, 56-sum($H$2:H2))))

MAX(0,...) should not be necessary; 56-SUM($H$2:H2) should suffice. I
tossed in the MAX(0,...) on the off-chance that 56-SUM() becomes
negative because of the vagaries of binary computer arithmetic.