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
Bookmarks