View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jake[_6_] Jake[_6_] is offline
external usenet poster
 
Posts: 17
Default Counting down formula


"Jake" wrote in message
...
How do I write a formula to calculate how many iterations it will take to
reduce a number by a given percentage until that result is less than 1.

Example, how many iterations will it take to reduce 100 by 0.1% until the
value is less than 1

100, 99.9, 98.001, ..... 0.99999

Thanks


Thanks guys, that works for me.