The dollar in absolute

stevembe

Well-known Member
Joined
Mar 14, 2011
Messages
501
Simple question probably but I was asked today why the $ sign is used for absolute reference and to be honest I know what it does by why the $? Anyone got any idea?
 

Some videos you may like

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.

shg

MrExcel MVP
Joined
May 7, 2008
Messages
21,779
Office Version
  1. 2010
Platform
  1. Windows
Maybe because the dollar is the world's reserve currency, and therefore immutable.
 

thisoldman

Well-known Member
Joined
Jan 5, 2014
Messages
1,074
Excel history goes back to 1982 with the software Multiplan, which used R1C1 style references. There was a conscious decision when Microsoft Excel was created to be compatible with Lotus 1-2-3, the "killer app" for PCs in the 1980s. Lotus had chosen A1 style notation, and used the dollar signs to distinguish between absolute and relative references. Lotus had copied Visicalc, an even earlier spreadsheet program.

For Excel to be successful, that is, to be profitable, Microsoft had to attract Lotus 1-2-3 users. So A1 cell notation, with the dollar sign as a reference modifier, was used because Lotus had used it.

The actual choice of the dollar sign glyph? The original spreadsheet programmers needed a singe glyph (symbol) that is easy to type, found on the (U.S.) keyboard, and the symbol has to be one of the 128 ASCII characters, the only computer character set available in the seventies and eighties. Other computer languages had already made engineers and scientists familiar with the dollar sign as a modifier for variables and references in programs. The spreadsheet designers simply imitated a notation style with which they were familiar.

From a coding perspective, R1C1 references are much easier to calculate "in your head." Who can remember that the cell 1,017 columns to the right of A1 is $AMC$1? Or is it $AMB$1 or $AMD$1?
 
Last edited:

Watch MrExcel Video

Forum statistics

Threads
1,122,491
Messages
5,596,460
Members
414,069
Latest member
StudExcel

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top