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

asked May 15, 2020 190k views

4 votes

4.9k 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

5.6k points

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

5.7m questions

7.4m answers