Recalculate a Total

I have a total figure in Column D, which needs to be allocated to Column C, based on the value in Column A (See Attached).

If Column A shows 'Good', then a tenth of the total of Column D is entered in Column C, leaving the balance to be allocated to the remaining Columns
e.g. A2 = Good, so 85.8 of the total goes in C2, leaving, 772.2 to be allocated to the remaining rows

A3 = Bad, so nothing is allocted to C3, which still leaves 777.2 to to be allocated to the remaining rows

A4 = Good, so a tenth of 777.2, namely 77.22 is given to cell C4, leaving a balance of 699.98 to be allocated to the remaining rows

How can I write a formula which can be entered in C2 to be dragged down to calculate the new balance to be allocated to each row based on Column A

Many thanks

Fotis1991,

That seems to do the trick, simple when you know how...

Many thanks