I have a calculation where I need to iterate and action several times, as follows:
For a certain count, I need to multiply by 1.1 and floor, so that: (Assume A1 as base value, and B2 as repeat count)
If B2=3, I need: =FLOOR(1.1 * FLOOR(1.1 * FLOOR(1.1 * A1 )))
Is there any way to make the multiplication and flooring occur the number of times indicate in B2 cell?
=FLOOR(A1 * (1.1^B2))
Will return bad output.