Questions tagged [google-sheets-circular-references]
Use for questions about using circular references in Google Sheets
3
questions
3
votes
1
answer
107
views
How do I check a set of numbers in different columns against numbers in different columns
I am trying to make a Lotto checklist. I have my own numbers in 6 columns A2:F2, and I have typed the winning numbers in H2:M2, 6 columns also. Now I want to check if my numbers in A2:F2 have any one ...
- 57
0
votes
1
answer
691
views
How to calculate a percentage with a circular reference
I want to calculate a percentage of profit where the percentage is an expense and therefore affects the profit.
Let's assume:
Revenue 100,000
Expenses 50,000
Profit Percentage 50%
Normally the ...
- 342
2
votes
4
answers
12k
views
Google sheets equivalent of self-referencing in Excel
This is, in my opinion, one big advantage Excel has over Google sheets is the self-referencing formulas. What I mean by that is: say in cell A1, I'm changing the value in there a,b,c. And according ...
- 1,024