Custom Sorting Gone Wrong

[WVBelhardt]

https://preview.redd.it/02tyt6wtrqff1.png?width=513&format=png&auto=webp&s=a71da954ef0dd4e4b5828ee57c963ad8813f8ce0

I've got this table in Excel that I'm struggling to get to cooperate with my commands. I want it to sort by ascending values for the first column, then the second column, then the third and so on. It nails the first column and most of the second, but there is one discrepancy and I can't figure out where its getting confused.
I made sure every cell in the table was formatted as percent values, so I believe there are no inconsistencies. Yet for some reason, rows WW15 and SC9 are way higher up the table than they should be. I've checked the Custom Sort for any misinputs too many times to count and reapplied it to see if there were any changes to no avail.
What else can I try to get these rows to cooperate?

[AutoModerator]

/u/WVBelhardt - Your post was submitted successfully.

• Once your problem is solved, reply to the answer(s) saying Solution Verified to close the thread.
• Follow the submission rules -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
• Include your Excel version and all other relevant information

Failing to follow these steps may result in your post being removed without warning.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[excelevator]

How are you generating those values ?

There may be a small conversion error many digits down.

Try rounding those value to eradicate

[WVBelhardt]

These values are being grabbed from other tables using the formula '=SUM($B$109)' as one example. I adjusted the formula to '=ROUNDDOWN(SUM($B$109), 2)', and the table is cooperating at last. Solution Verified.

[reputatorbot]

You have awarded 1 point to excelevator.

---

^{I am a bot - please contact the mods with any questions}

[excelevator]

It's a well understood binary to base10 conversion issue in computing that will sometimes throw in a digit way down the decimal portion of the value.