View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jamesmcg69 jamesmcg69 is offline
external usenet poster
 
Posts: 1
Default creating a 'routine'

Please can someone tell me how easy/difficult this is...

I need to create a routine whe

1. The values of a number of cells in my spreadsheet are built into an
equation.
2. The equation is run repeatedly until the value = 0
3. The information I need is the number of times it is run before value = 0

I have done this 'long hand' but would like it built into the function
contained within one cell. What are the key functions I need to be looking at
in order to create this?

Thank you.

James