Formula Novice

Copper Contributor

I am a formula novice. I am struggling to figure out this one. Any help will be appreciated!

 

All the percentages should equal to 100%. If the Pool 1 percentage changes (or for that matter any percentage changes), I need it to pull from the remaining percentage (8.14%). Does this make sense?

 

First NameLast NamePercent
DougS0.51000
DonnieB0.05000
JamesB0.05000
DevinH0.05000
RobG0.05000
KellyM0.02000
JerryH0.02000
Pool 1I0.01860
Pool 2I0.15000
RemainingS0.08140
  1.00000
2 Replies

@jburkh02 

If the total cell currently contains a formula, simply enter 100% in this cell.

In the cell above, enter the formula

=total_cell-SUM(cells_above)

See the screenshots for an example:

HansVogelaar_0-1706650080506.png

 

HansVogelaar_1-1706650135697.png

@HansVogelaar Thank you!