Randomthots wrote:
To CPH and Mr. Pitonyak: R1C1 addressing is just an alternative
nomenclature for specifying cells. Instead of cell D3 you would have
cell R3C4.
Note that R3C4 actually translates to $D$3.
(History lesson. VisiCalc, the original spreadsheet, made all references
in absolute form. "D3" in VisiCalc was equivalent to "$D$3" in modern
spreadsheets. Every time you copied a formula, VisiCalc would ask you
whether each row and column in each reference was to be taken as
absolute or relative, which could be quite a bother after a while. So
Microsoft, when they designed Multiplan, came up with a new scheme;
"R3C4" would be equivalent to D3, but if you wanted to refer to the same
cell relatively from, say, E5 (R5C5), you could refer to it as
"R[-2]C[-1]". The idea was a good one, and I freely admit I often would
prefer it to the dollar-sign convention that Lotus applied to 1-2-3.
However, 1-2-3 was the winner of the DOS spreadsheet wars, and Microsoft
went with the Lotus convention when they designed Excel, just like
everyone else, although Excel allows the RC notation as an alternative.)
--
John W. Kennedy
"...when you're trying to build a house of cards, the last thing you
should do is blow hard and wave your hands like a madman."
-- Rupert Goodwins
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
