In Google Sheets, I can define a variable such as
interestRate by using Data -> Named Ranges.
Then I can use the variable
interestRate as if it is a number, like
But what if in Sheet2, I want to experiment with a different interest rate, such as
7%, and want to just go to Sheet 1, Select All, Copy, and Paste it to Sheet 2?
In that case,
interestRate still refers to the number in Sheet 1, but I want it to be relative to current sheet's cell
B1, for example, not cell
B1 in Sheet 1.
How can it be done?