Just to add. If B1:B3 hold 20%,10%, 12%, then another option would be the
following array formula. This idea subtracts 1 from each number.

=A1*PRODUCT(1-B1:B3)

--
Dana DeLouis
Win XP & Office 2003


"Fran" wrote in message
...
Harald - Yes - that DID work if I am using ONLY 10%. How did you come up
with
0.9? I am wondering though - I just used 10% in all three cases as an
example. Actually a student asked me this same thing using different
numbers
- like 100 - 20% and then 10% and then 12%. Actually exponential worked
great if it's the same percentage. Is there a way to do different
percentages? I started out (in Cell B1) saying =A1-A1*10% (which gave me
my
90%) but how can I USE that answer and say take 12% away from THAT????

"Harald Staff" wrote:

=A1*0.9^3

HTH. Best wishes Harald

"Fran" skrev i melding
...
For example, take a number 100 (A1). In the formula in B1 - take A1
and
multiply it by 10% - TAKE THE RESULT of that and Multiply it by 10% and
take
the RESULT of thank and multiply by 10%. Answer should be 72.9 Take
10%
of
100 would be 90, 10% of 90 would be 81, 10% of 81 would be 72.9. How
do I
write that formula in ONE LINE??????