asked 95.7k views
5 votes
The formula in cell A2 is =B1+10. The formula is copied pasted to sell A3, so A3 formula would be what

asked
User Mgol
by
7.8k points

1 Answer

3 votes

Since the formula in A2 is =B1+10 and this formula was copied to A3, the formula in A3 is also =B2+10.

To solve this problem

Since A2's formula, =B1+10, was copied to A3, A3's formula, =B2+10, was likewise copied to A2. This is so that the relative references are changed to reflect the formula's new location when it is duplicated.

So, Because A3 is one row below A2, in this instance the B1 reference in the original formula is updated to B2.

Therefor, the formula in A3 is also =B2+10.

answered
User Roy Chan
by
8.9k points
Welcome to Qamnty — a place to ask, share, and grow together. Join our community and get real answers from real people.