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

You are really doing

..49 - .10 - .025 - .1350 = .23

Make sure you percentages are number (not string) and your currency is
formated as pound (not string).


"Kirk" wrote:

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

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