Questions tagged [google-sheets-circular-references]

Use for questions about using circular references in Google Sheets

Filter by
Sorted by
Tagged with
0
votes
1answer
414 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 ...
2
votes
4answers
6k 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 ...