Guide to Using $ in Excel Formulas
There might be times when you do not want Excel to adjust all or part of your formula automatically. For example, you may have a table of standard multipliers that you use in the formula and want the same cell to always be used to multiply. The answer: an absolute reference.
You can create an absolute reference by using $ in Excel formulas. Insert $ to the left of the cell coordinate that you want to stay the same. If you want C2 to remain the same, then C2 becomes $C$2.
Cell References
Most of your formulas will refer to data in various cells in your worksheet. Your formula can refer to a cell’s data in one of the following ways:
Additional Help
Microsoft Excel is a powerful tool with options for professionals in many different occupations. Because a limited post such as this can’t provide information on every possible formula, be sure to use the online help from within Microsoft Excel. In particular, the “Insert Function” tool on the “Formulas” ribbon will walk you through the functions and the required parameters.
Choose a Seminar and Save $10
Microsoft Excel: Beyond the Basics
- CEU: 0.6
- CPE: 6
- PDU: 6
Virtual Seminars:
-
May 29
-
May 30
-
Jun 3
-
+ 22 more dates
In-Person Events:
- Jun 3, CENTRAL TIME ZONE, US
- Jun 4, PACIFIC TIME ZONE, US
-
+ 1 more dates
