And do you need just the final answer (ie 1), or are the intermediate numbers important too?

All this is easy enough to do in VBA. How to do it with formulae...well, I'm sure it can be done, but it'd take some work. Are you up for a programmed solution, or do you want it in formulae?