What does the $ symbol mean in a formula?

M

Mangesh Yadav

The $ is used for absolut referencing. For e.g lets take your formula

=G8*($A$14*2)*100


suppose you enter this formula in cell B2, now simply copy this formula one
cell to the right (C2) by and one cell down (B3).

C2: =H8*($A$14*2)*100
B3: =G9*($A$14*2)*100

So you see that The original G8 has changed, whereas $A$1 remains the same
in both the new formulae because of the dollar signs.

Mangesh
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel formula ^ 1
Excel Count If Formula Question 1
what does "^" symbol mean in excel 2
I am trying to use the IF and SUMIF function on Excel 8
$ Symbol 3
What does "" mean in Excel? 2
What does the object anchor symbol mean? How's it used? 1
what does the & symbol do in a formula? 4

Top