21, Feb, 2019

What is $ (dollar) sign in excel formulas?

What is $ sign in excel formulas?

For example, if you have formula “=A1+B1” in cell C1, and drag it downward. (or copy the formula to other cells).

The values in column C will automatically equal those in column A + Column B.

please see the screen shot below,

excel automation

 If you add the dollar sign inside the cell A1 like A$1, and drag it downward, you will have the column C equal the value which is equal to A1+B1, A1+B2, A1+B3,… Etc

see that A1 is constant for all calculations.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes:

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>