Thread: # of iterations
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rick Rick is offline
external usenet poster
 
Posts: 334
Default # of iterations

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.