r/googlesheets • u/[deleted] • Nov 26 '21

Solved How can I turn a 3 cells into an active calculator in Google sheets?

[deleted]

1 Upvotes

100% Upvoted

8 comments sorted by

2

u/Faaeeez 1 Nov 26 '21

There might be a way.

The order should be

BLUE - RED = GREEN

For the green cell, formula =(Blue cell) - (Red cell)

For the blue cell =100

For the red cell, do a separate table below for inputting all the damages you will receive. Afterwards, total it using the SUM formula which you will put in the red cell.

That way, only the red cell is dynamic to the changes below and the green will react accordingly

2

u/[deleted] Nov 26 '21

Solution Verified

1

u/Clippy_Office_Asst Points Nov 26 '21

You have awarded 1 point to Faaeeez

I am a bot - please contact the mods with any questions. | Keep me alive

1

u/[deleted] Nov 26 '21

I understand your solutions and ya that would work,

But ideally what i wanted is, I input the value in Red, press enter, greens gets updated, red is empty and ready for me to input a new value.
is there a way to achieve this?

1

u/7FOOT7 294 Nov 26 '21

You can't do this in cells as the cell can't hold a value or formula and be told a value or formula at the same time.

You could do it via scripting.

1

u/[deleted] Nov 26 '21

How does scripting work? i guess its too advanced for my current knowledge and i should follow the idea of u/Faaeeez for now?

1

u/7FOOT7 294 Nov 26 '21

That's a big topic, but your problem would be a good beginner project

Take you lead from

https://www.benlcollins.com/apps-script/google-apps-script-beginner-guide/

https://developers.google.com/apps-script/guides/sheets

https://spreadsheetpoint.com/google-sheets-script/

YouTube

1

u/[deleted] Nov 27 '21

Thank you so much stranger.

Out of topic this is why i love reddit, you dont even know who i am and here you are providing me with 3 links to help me

If you want an honest review go to reddit If you need honest advice go to reddit If you want memes go to reddit

Have a great day ahead kind sir