What formula have you tried?

Do you want the percentages to be percentages of the original A1 value, or
of what is left after the previous percentage has been subtracted? For
example if you were subtracting 50% then subtracting another 50%, do you
want to be left with zero or with 25%?

If the former, then =A1*(1-A2-A3-A4)
If the latter, then =A1*(1-A2)*(1-A3)*(1-A4)
--
David Biddulph

"Kirk" wrote in message
...
Hi,

I am trying to work out a value.

A1 A2 A3 A4 A5
£0.49 10.00% 2.50% 13.50% ?

A5 needs to calculate A1 - A2 -A3 -A4

I cant get it to work. Please help