Creating a Compound Table for a Variable Term

[tsroque]

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?

 

[SpillerBD]

50*(0.8^3)

=B4*(B8^b9)

 

[tsroque]

That does it! Thank you!