Forum Discussion

mikeocain's avatar
mikeocain
Copper Contributor
Jan 24, 2024

Circular Reference

I have a spreadsheet I am building that has a cell ( we'll call B20) that is a percentage of the sum of B1:B15. The problem is that some of the values in B1:B15 need to be calculated as a percentage of the value in B20. Can this be done without creating a circular reference?

2 Replies