tsroque
Board Regular
- Joined
- Jan 19, 2007
- Messages
- 127
- Office Version
- 365
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?
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?