Dollar ($$$) Symbol use in Microsoft Excel Formula

 Brief Introduction

            In Microsoft Excel the Dollar Symbol or Sign ($) is mostly used in Formulas where we want to fix or absolute the reference or location of the cell to stop it from changing, without $ sign in the formula the reference or location of cell change gradually, so it is important to know how & where the Dollar $ use.    

Purpose:

Use to fix or absolute the reference or location of the cell to stop it from changing.

              This article explains in simple terms how to use the Dollar Symbol or Sign ($) in Microsoft Excel formulas. It takes a step-by-step approach, & the following below contents we will touch in this post.

1. Brief introduction of Relative and Absolute reference concepts.

1. Relative reference in Microsoft Excel with Example.

1. Absolute reference in Microsoft Excel with Examples.

Let’s start to learn something new about the Dollar Symbol or Sign ($) use in Microsoft Excel Formulas.                

1.  Brief introduction of Relative and Absolute reference concepts.

             Relative reference is the basic or default option of Microsoft excel formulas, every formula, we used in excel without Dollar $ Sign is carrying the relative reference, it means that it changes across the other cells when we drag or copy paste the formula to other cells, while Absolute reference carrying the Dollar $ Sign, which not change across the other cells by dragging or copy-paste option. Below in this article through various examples, I will explains the difference between Relative Reference & Absolute Reference.

    For continue reading the article & download free the Complete Practice of Concern Topic of Microsoft Excel File, Click on the below Learn More Button,