I need to write a function that returns 3 results. One is the actual
result. The other two are intermediate results that will be passed
back on the next call.

I'm not sure how to return more than one result and I'm also not sure
what the invocation code in the calling cell would do with them.

Is there a way to have the results go into adjacent cells? If the
function is called from B5, can it return one result and put the
intermediate results in C5 and D5?

If so, can someone post sample code snippets for doing something like
that?

Thanks a bunch