S
Sandy
In S2 I have =IF(R2="","",R2*0.034+0.2) extended down to S9.
In T2 I have =IF(R2="","",R2-S2) extended down to T9.
In U2 I have =T2.
In U3 I have =IF(R2="","",U2+T3) extended down to U9. In other words a
running total.
When I enter an amount (£) in R10, cells S10 and T10 automatically update
but not U10.
Why won't the formula in U9 extend to U10?
Sandy
In T2 I have =IF(R2="","",R2-S2) extended down to T9.
In U2 I have =T2.
In U3 I have =IF(R2="","",U2+T3) extended down to U9. In other words a
running total.
When I enter an amount (£) in R10, cells S10 and T10 automatically update
but not U10.
Why won't the formula in U9 extend to U10?
Sandy