Locking formula values in google sheets-CodePudding

Question

I'm trying to make a google sheet for calculating my net income over a set period of time. I have all the things but one thing figured out. That one thing being, I don't know how to lock a value in a formula to make it say the same for when I select and copy the cell formula to other cells. I've tried googling but all I can find is stuff about how to lock a cell to keep it from being edited, so I don't know if this is a thing that can be done. I'm very new to google sheets (and any form of sheets) so I don't have much idea as to what I'm doing. Thus far in my journey google has been able to help me greatly, but now that I've exhausted all other resources, I figured it couldn't hurt to ask you guys. Some help would be greatly appreciated, Thanks in advance. If my question wasn't very clear or needs rewording please let me know and I will work to correct whatever it is that is unclear.

Link

(this isn't the actual form I'm using, this is just a scratch form that you guys can type formulas into and leave comments on)

    https://docs.google.com/spreadsheets/d/1at6TT3HAcMNswNL0rZqLeScTBEEiCff2fGgbT3vxHK0/edit?usp=sharing

Edit

So I've been doing some searching and working on the sheet, and I've decided to drop one of the things I was going to do because it didn't make much sense. So now the situation is that I need to have a value *change dynamically* as I continue to add more rows. What I'm trying to do now is have the cell formula change to add together the cell, say B3, and the cell above it, B2, and have that stored on another cell. I don't really know how to go about doing this, so any help or advice is greatly appreciated. Thanks in advance and sorry for the sudden change.

CodePudding user response：

If you want to just copy the value and paste, I believe that is CTL SHFT v. If you want to copy the formula and paste it so that it refers to the same cells when it's copied, then you need to change the references so that they are static. For instance, if the formula refers to A1 and you copy it one column over it will change to A2, and if you copy it one column over and one row down it will change to B2. If the formula refers to $A$1, it will always refer to A1. You can do this manually, or you can highlight the cell reference and press F4 to change it to a static reference.

Hope I understood the problem correctly.

CodePudding user response：

Based on your statement with ...how to lock a value in a formula to make it say the same for when I select and copy the cell formula to other cells, I suppose this is what you're experiencing (feel free to correct me if I'm mistaken) :

Example:

Let's say this sample formula above on C1 is what you'll be copying

Once the copied formula has been pasted on cell C2, the formula reference changes

Alternative Suggestion

Aside from

Used INDIRECT function to sum up A1 & B1 cells on C1

Once formula with INDIRECT function has been copied to cell C2, the formula reference value remained the same.