Answer to Question #128827 in Excel for kern

Question #128827
What is the difference between these cell addresses: $A1, A$1 and $A$1?
1
Expert's answer
2020-08-09T08:44:47-0400

1) $A$1 - it is an absolute reference to cell A1.

For example, let the number 2 be written in cell A1. Column A contains numbers from 1 to 5, and the values in column B will be obtained by multiplying the left cell by 2. Then we write the formula "=$A$1*A3" and stretch down. It can be seen that the second factor is changing, and the first is unchanged.




2) $A1 - it is a relative column reference. That is, when you drag through the entered formula, only the row number will change, and the column will be constant.


3) A$1 -it is a relative string reference. That is, when you drag through the entered formula, only the column number will change, and the line number will be constant.


Need a fast expert's response?

Submit order

and get a quick answer at the best price

for any assignment or question with DETAILED EXPLANATIONS!

Comments

No comments. Be the first!

Leave a comment

LATEST TUTORIALS
New on Blog
APPROVED BY CLIENTS