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