Forum Discussion
Unable to get cells with % Formulas to add up to100% but yet the Sum Total in the cell shows 100%
Example Column Cell K5=SUM(C5,E5,G5,I5) Then all of Column K is added up with the following formula K31 =SUM(K5:K30) Column L, rows 5 thru 30 are a % of the rows Total (Cell K31) or the formula o...
If all formulae are correct that's most probably Floating-point arithmetic may give inaccurate result in Excel - Microsoft 365 Apps | Microsoft Learn
To calculate each percent try to use ROUND with, let say, 6 digits.