I have this spreadsheet set up so that the third column shows what percentage of the total each of the Samples is. I now want to remove the percentage formula from one cell only (the 456 in the Sample 10 row). I'm very poor at Numbers formulae and can't figure out how to do this. Can anyone help?
[Edited by Moderator]
iPad mini 5, iPadOS 18
Donnie Ashworth wrote:
I now want to remove the percentage formula from one cell only (the 456 in the Sample 10 row).
If you just want to remove the percentage then click on the cell with 5% and hit the delete key.
Did you mean something else?
SG
Thanks for your response. I tried this, and the formula and contents of the cell are gone—yet the formula is still functioning somehow. In other words, if I alter the number 456 to something else, all of the percentages above change. So this cell is still being counted in with the percentages.
In the screenshot, notice that I changed 456 to 2000, and this is reflected in all the percentages above, whereas there should be no change in them.
Never mind, figured it out. I just needed to remove the last sample from the total. Thanks!
Remove formula from one cell
