Forum Discussion
mikeocain
Jan 24, 2024Copper Contributor
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?