paulpeyton
Technical User
How do I write a formula (or is there some other way) to take a static percentage, say 10%, and calculate the number of times that percentage can be taken of a number to ultimately reach a particular threshold.
EX. 10% of 10 is 1
10-1 is 9
10% of 9 is .9
9-.9 is 8.1
10% of 8.1 is .....
to reach a threshold of 8 equals three attempts.
Is there a way to do this in one formula applied to a single cell? What is the formula or function?
Thanks for the assistance!
Paul
EX. 10% of 10 is 1
10-1 is 9
10% of 9 is .9
9-.9 is 8.1
10% of 8.1 is .....
to reach a threshold of 8 equals three attempts.
Is there a way to do this in one formula applied to a single cell? What is the formula or function?
Thanks for the assistance!
Paul