In the attached file the values in column K ("Unique value %) should be rounded to 2 decimel but the "Total %" in column L should still stay exactly 100%.
So I can't use directly the ROUND function, as it messes up the 100 value, like this:
Formula:Please Login or Register to view this content.
But is there a way to propotionally add/remove value to round the numbers to 2 decimel and keep the total value 100?
The formulas in J,K,L columns are there all thanks to member Estevaoba
Also there could be an instance where there are 3 values all 33,333333%. So rounding them to 100 could be an issue. Right?
Bookmarks