Forum Discussion
Formula Novice
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 Name | Last Name | Percent |
| Doug | S | 0.51000 |
| Donnie | B | 0.05000 |
| James | B | 0.05000 |
| Devin | H | 0.05000 |
| Rob | G | 0.05000 |
| Kelly | M | 0.02000 |
| Jerry | H | 0.02000 |
| Pool 1 | I | 0.01860 |
| Pool 2 | I | 0.15000 |
| Remaining | S | 0.08140 |
| 1.00000 |
2 Replies
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 Thank you!
