Sep 22 2021 06:46 AM
Hi Guys,
I want to add a formula to the column to the first cell, and then to be repeated for each new row, knowing that I want to disable this column because it is calculated and I do not want the user to change it. In addition, I still want the end-user to change other columns.
Sep 22 2021 06:51 AM
Sep 22 2021 06:52 AM
Sep 22 2021 07:01 AM
Sep 22 2021 07:02 AM - edited Sep 22 2021 07:06 AM
Sep 22 2021 07:12 AM
Sep 22 2021 07:13 AM
Sep 22 2021 07:21 AM
Sep 22 2021 07:41 AM
This formula will multiply column B with Column C for each row. Calculated with ROWS:
=INDEX(B2:C11;SEQUENCE(ROWS(B2:B11)),1)*INDEX(B2:C11;SEQUENCE(ROWS(B2:B11)),2)
Lock and password protect column A
Sep 22 2021 08:01 PM
So this calculated column, does the user have any use for it? or its just for your own use?
Jun 06 2022 01:41 PM
@mtarler I am making a checkbook that need to continue the balance forward. Is there a clear instruction for making a column a table? I am so tense right now because I am afraid of making a mess of things. Right now I have to manually add the formula and it is exhausting.
thanks for your help
Jun 06 2022 02:02 PM
Aug 02 2022 01:48 PM
@mtarler : Sorry this took me so long to get back to. I don't know how to look for what I previously asked.
I am working with a checkbook type of situation. I am not sure what "deactivate the column" means. This is what I need.
The formula for the balance of checkbook at the current moment has to be added after each transaction. This is a time waster and I know that there are solutions for this. I need it to automatically add or subtract to or from the last balance and show the new balance. I just want the formula to repeat. My problem is that when I add a new transaction, the previous balance must be addressed in the formula and then the current row + or - from that to get new balance. I hope that I've made myself clearer than the first time I requested help.
This is the formula I use, "H" is the balance column [ F is the expense, G is the income]
=H-F(current row)+G(current row)
I hope this is understandable. Thanks again for your assistance.
Aug 03 2022 09:37 AM
Aug 03 2022 10:14 AM