RC format formulas
 

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

RC format formulas
 

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

RC format formulas
 

Great tip! Thanks

Bill


Dave Peterson wrote:
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