Forum Discussion
LisaMarie1981
Jul 04, 2022Brass Contributor
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...
Riny_van_Eekelen
Jul 04, 2022Platinum Contributor
LisaMarie1981 Let's say A1 holds 60% (or 0.6) the A2 should contain =1-A1 to display 40% (i.e. 0.4)