Formula that can manipulate a column of number to add up to 100.0%

[CEJ]

I am looking for a formula that can manipulate a column of numbers to add up to 100.0% even though the actual sum is 99.9%

Any assistance would be greatly appreciated.

Thank you!

 

[Joe4]

Here is one way, that "adjusts" the last value, to ensure it hits exactly 100%.

Let's say that you have values in A1:A10, and you want the percentage of the total to be in column B.
So in cell B1, enter this formula, and copy down to cell B9:

=ROUND(A1/SUM($A$1:$A$10),3)

Then in cell B10, enter:

=1-SUM(B1:B9)

 

[CEJ]

Thank you very much! I apologize for not giving you more data as an example. I was trying to figure out how to add the data to my original message.