I have used User Defined Functions in the past in order to control the
order of a calculation and use iterative methods (eg constantly
reducing some value and adding it to some other variables as you go
round a loop, until the value gets to zero). I could never get the hang
of Excel's iteration.

Hope this helps.

Pete