Creating a Compound Table for a Variable Term

tsroque

Board Regular
Joined
Jan 19, 2007
Messages
123
Hi!

This is NOT an compound interest question. I need to create a compound formula or table to reach a desired answer.

EXAMPLE:
So if I need to decrease 50 by 20%, 3 times (variable)
------------------------
1) 50 x .8 = 40
2) 40 x .8 = 32
3) 32 x .8 = 25.6
------------------------
Answer: 25.6

What is given is 50 (B4), 0.8 (B8) and 3 (B9)
B9 is my variable. It could change to ANY number, but I need the formula to ONLY calculate THAT many times.

What is the best way to do this?
 

Forum statistics

Threads
1,085,475
Messages
5,383,906
Members
401,864
Latest member
MaryKayte

Some videos you may like

This Week's Hot Topics

Top