I’m looking to set up a dynamic system in my Google Sheets where the value in one cell changes depending on the value of a different cell. Specifically, I want it to increase by 1,000 for every point over 20, and decrease by 1,000 for every point below 20. For instance, if I start with a value of 50,000, it should change based on another cell’s number. For example, if Cell A is 27, then Cell B should reflect 57,000, and if Cell A is 13, Cell B should indicate 43,000. I’ve tried multiple approaches but haven’t found a successful solution yet. Any suggestions would be greatly appreciated!
hey, try usin this formula in Cell B: =50000 + (A1-20)*1000. it calculates the adjustment using the value in cell A1. hope it helps!
You can also try conditiional formatting if you want more than just number change. It can highlight or style cells based on A1 so u know which ones are recalculated.
If you need a more dynamic approach or want to adjust the initial value of 50,000, you could use a named range or put that base value in a separate cell, say C1, and then use a formula like =C1 + (A1-20)*1000 in Cell B. This allows you to easily modify the starting amount without changing the formula itself, which can be useful if you’re managing multiple scenarios or datasets.