Why use cell references?

Cell references make calculating formulas extremely useful. It is one of the most basic ways of calculation, other than simply typing in numbers. However, it offers a great benefit. When cell references are used, and those cells are changed, the calculations are automatically updated. This is a blessing and is very useful.

cell-references-1
Cell Reference vs. Calculation “by hand”

Why does it matter? It is the same Total. Although you are not wrong, there is something inherently missing. If I change the values in the cells, I would have to recalculate the basic math version while Excel automatically does that with cell references. It is more work on my side.

cell-references-2
Excel recalculated the cell referenced equation but not the other one.

It doesn’t matter what the formula is or how it looks, unless it is in a cell reference format, Excel will not recalculate it.

cell-references-3
No changes to the basic, two changes to the cell referenced equation

I can continue to provide examples. This shows that unless the user is familiar with cell references, it would be incredibly difficult to use large workbooks. Having to recalculate everything every time it changes would take an incredible amount of time.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s