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 per...
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!
