As noted, these questions aren't so much Excel questions as algebra
questions, and getting used to formulating them in statements Excel
understands.
If you want 90% of something, you're really multiplying by 0.9 (which equals
1 minus 0.1 -- hence the first equation).
If you want to reduce by 15% and then 4%, you are really multiplying by 0.85
(1 minus 0.15) and then multiplying that result by 0.96 (1 minus 0.4).
Since you can put that all (and much, much more) into one equation, you can
write it as
A B
1 ## =A1*.85*.96

Try it.

HTH

"bazza825" wrote:


vandenberg p Wrote:

Algebra, not Excel.

=100*(1-0.1)*(1-0.1)
=100*(1-0.1)^2


Many thanks for that :) It works fine, but i'd love to understand why
Also, what would i do if i had two completely different percentage
numbers (eg 15 and 4)?? Where would i put them?

Could you possibly explain it to me please? I dont understand (1-0.1)
or the ^... never was that good at math.

thanks again
barry


--
bazza825
------------------------------------------------------------------------
bazza825's Profile: http://www.excelforum.com/member.php...o&userid=33241
View this thread: http://www.excelforum.com/showthread...hreadid=530672