Hello:

Algebra, not Excel.

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

Take your choice. As long as the two percentages are the same the
second is probably the choice. If the two percentage can be different
then the first is the choice.

Pieter Vandenberg

bazza825 wrote:


: Hi, i've just joined the group because i want to learn about the more
: 'in depth' facilities of excel (and also hopefully access in future).

: I want to be able to calculate from a resultant calculation (does that
: make sense?).
: eg: 100 less 10% less 10%

: Now the result should be 81 (because it's a percentage of a resultant
: calculation)....

: The only way i can do it is by using allsorts of empty cells and dump
: numbers in it, but it's getting too complex with a quantity of
: numbers...

: I'm stuck, could anyone help please?

: (In simple terms please, because i'm not a guru yet)

: thanks in advance
: barry


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