Skip to main content
Library homepage
 
Loading table of contents menu...
Workforce LibreTexts

18.2: Why not just add the Numbers and not the Cell Locations?

  • Page ID
    13699
  • \( \newcommand{\vecs}[1]{\overset { \scriptstyle \rightharpoonup} {\mathbf{#1}} } \) \( \newcommand{\vecd}[1]{\overset{-\!-\!\rightharpoonup}{\vphantom{a}\smash {#1}}} \)\(\newcommand{\id}{\mathrm{id}}\) \( \newcommand{\Span}{\mathrm{span}}\) \( \newcommand{\kernel}{\mathrm{null}\,}\) \( \newcommand{\range}{\mathrm{range}\,}\) \( \newcommand{\RealPart}{\mathrm{Re}}\) \( \newcommand{\ImaginaryPart}{\mathrm{Im}}\) \( \newcommand{\Argument}{\mathrm{Arg}}\) \( \newcommand{\norm}[1]{\| #1 \|}\) \( \newcommand{\inner}[2]{\langle #1, #2 \rangle}\) \( \newcommand{\Span}{\mathrm{span}}\) \(\newcommand{\id}{\mathrm{id}}\) \( \newcommand{\Span}{\mathrm{span}}\) \( \newcommand{\kernel}{\mathrm{null}\,}\) \( \newcommand{\range}{\mathrm{range}\,}\) \( \newcommand{\RealPart}{\mathrm{Re}}\) \( \newcommand{\ImaginaryPart}{\mathrm{Im}}\) \( \newcommand{\Argument}{\mathrm{Arg}}\) \( \newcommand{\norm}[1]{\| #1 \|}\) \( \newcommand{\inner}[2]{\langle #1, #2 \rangle}\) \( \newcommand{\Span}{\mathrm{span}}\)\(\newcommand{\AA}{\unicode[.8,0]{x212B}}\)

    To extend this example, I could place the same numbers in A3 and B3. This time, however, instead of using the cell references to add together, I could manually, just add the numbers together in C3 as displayed below.

    clipboard_e46d3e8314a04b35d6df2c56ad34427fd.png

    While this will get me the correct data, it is risky to do this, because if the data ever changes in any of the cells, the answer will no longer be correct. For example, let's pretend that the Number columns corresponded to cars sold in February at an automotive dealership. Recently, they discovered a recording error, they did not sell just 2 and 3 cars, they sold 20 and 30! Updating the calculation table leads to the following results.

    clipboard_efb6d976815c3820fdddf8fce4d5c5299.png

    Row 2 has the correct sales numbers, but row 3 does not because the user used numbers instead of cell references. It is always wise in Excel to use cell locations instead of numbers, even if it means creating extra rows and columns. That way, if any of your data changes, Excel immediately can recalculate the information. This is also helpful for autofill.


    This page titled 18.2: Why not just add the Numbers and not the Cell Locations? is shared under a CC BY license and was authored, remixed, and/or curated by Nick Heisserer (Minnesota State Opendora) .

    • Was this article helpful?