Which column and row references are updated when you copy the formula: =$A$9-B2?

asked May 15, 2020 190k views

4 votes

7.5k points

Please log in or register to add a comment.

1 vote

Answer:

Column A and Row 9

Step-by-step explanation:

The Expression "=$A$9-B2" has dollar ($) sign which means column A is fixed and row 9 is fixed.

ControlPoly answered May 21, 2020

8.4k points

Welcome to QAmmunity.org, where you can ask questions and receive answers from other members of our community.

8.8m questions

11.4m answers