Forum Discussion

LisaMarie1981's avatar
LisaMarie1981
Brass Contributor
Jul 04, 2022

If one cell is a percentage how do I populate the second cell to be the opposite percentage?

If I type 60% in the cell below, I want the cell below it to automatically change to 40%. If I change it to 70% then the number below automatically changes to 30% etc. Is there a formula for this ple...

Resources