# of iterations

R

Rick

I am trying to figure how many iterations it takes 100 to go below 50 with a
decay rate of 20%. i.e. 100-(100*.8)=80 then 80-(80*.8)=64...and so on. I
am trying to set this up in one cell. Thanks.
 
C

carl.manaster

Hi, Rick,
I am trying to figure how many iterations it takes 100 to go below 50 with a
decay rate of 20%. i.e. 100-(100*.8)=80 then 80-(80*.8)=64...and so on. I
am trying to set this up in one cell. Thanks.
Click to expand...

I think you're looking for this:

=LN(0.5)/LN(1-A1)

Where your rate, 0.2 in this case, is stored in A1.

Peace,
--Carl
 
Top