We use a column of numbers and divide each one by the total to see the % each
one should be allocated in other formulas. The sum total should add to 100%
and it does in the sum cell. However, when using for other purposes, the
column does not add up. It appears the system retains the numbers to an Nth
decimal that do add; when displaying less decimals, a rounded number, they do
not add to the total. When using a rounded number for further calculations,
the answer is off also.