Write your formula any way you want (make sure it points to the other
worksheet).

Then tools|Options|General tab and check R1C1 Reference style.

You'll see the way it works.

(Let excel do all that work for you!)



bill wrote:

All,

At the risk of asking a dumb question - here goes:

Can an RC formatted formula reference cells on other worksheets? If so,
how?

TIA,

Bill

--

Dave Peterson