98.0k views
4 votes
Gabriel needs to create a formula that does not change when it is copied to cell b2. which formula should he create?

User Baldarn
by
7.9k points

1 Answer

2 votes
=sum(1+1) it's a simple formula and won't change from any cells. Another you can do is to put a value in a specific cell, let's say, C3. Then have a formula that says, =sum(C3+2). But if you REALLY wanna impress someone - put a value in A1 - anything at all. Then put this formula in any other cell you want. If you change cells, you get a different answer. If you change the # in A1, you get different answers, all thanks to the RANDom function. =SUM((RAND()*100)+A1)