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??????

=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??????

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??????

He assumed you wanted the results you showed. 10% of 100 is NOT 90%, it's 10%.


On Sun, 7 Nov 2004 13:19:02 -0800, "Fran"
wrote:

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??????

This will always be very complicated unless you and your students recognize
that 1% is nothing but 0.01. Students of all kinds should.
This would be a readable solution:
=A1*(1-20%)*(1-10%)*(1-12%)
and shorter, since (1-20%) equals (1-20*0.01) equals (1-0.2) equals (0.8) :
=A1*0.8*0.9*0.88

HTH. Best wishes Harald
(significant digits logic deliberately left out of the discussion; Excel
doesn't care anyway)

"Fran" skrev i melding
...
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??????

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??????

Fran

Your terms are not correct.

10% of 100 is 10, not 90

To get 72.9 enter in B1 =((A1*0.9)*0.9)*0.9

Could also be written as =A1*0.9*0.9*0.9

I just stuck the parens in so's you could see the steps.

Gord Dibben Excel MVP

On Sun, 7 Nov 2004 12:30:01 -0800, "Fran"
wrote:

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??????