I P Basic Formulas in Excel N


When we are entering formulas into a spreadsheet we want to make as many references as possible to existing data. If we can reference that information we don't have to type it in again. AND more importantly if that OTHER information changes, we DO-NOT have to change the equations.

If you work for 23 hours and make $5.36 an hour, how much do you make? We can set up this situation using

  • three labels
  • two constants
  • one equation

Let's look at this equation in B4:

  • = B1 * B2
  • = 23 * 5.36
Both of these equations will produce the same answers, but one is much more useful than the other.
DO YOU KNOW which is BEST and WHY?

It is BEST if we can Reference as much data as possible as opposed to typing data into equations.


I P Basic Formulas in Excel N

1422015

 Choose:   INTEK home   I   training  I   by Jim Tracy   I