Extend formulae

[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

 

[Per Jessen]

Hi Sandy

Change the formula in U3 and down to:

=IF(R3="","",U2+T3)

Regards,
Per