Rounding values to 2 decimel while keeping total 100%

Fusionista · Apr 17, 2024

Hello!
In the attached file the values in column K ("Unique value %) should be rounded to 2 decimal 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.

But is there a way to propotionally add/remove value to round the numbers to 2 decimal and keep the total value 100?

Also there could be an instance where there are 3 values all 33,333333%. So rounding them to 100 could be an issue. Right?

So I created a new worksheet with some data. The original worksheet has many-many more rows. But I chose those three clients.
Also started with a helper column S, but have no idea how to continue from there on...

The problems are:

1.The column M should equal 100 for each client, but ALS has only one value in one month. But the calculation still gives 100 for it.
So there's something wrong with the formula?

2. Client UMM has a total of 100,08 in column P, so the excess 0,08 should be distributed between the values of client UMM in column P.

3. Client VAU has a total of 99,99, so 0,01 should be somehow added to one value in column P.

It should continue with extra helper columns, but what should be the next one then?

Uploaded the Excel file here: Easyupload.io - Upload Files and Share Them Easily

awoohaw · Apr 17, 2024

Fusionista said:
Column P values come from this formula

Excel Formula:

=IF(O2=""; ""; ROUND(O2 / SUM(FILTER($O$2:$O$50000; ($O$2:$O$50000 > 0) * ($I$2:$I$50000 = I2))) * 100; 2))

So it calculates the hours in column O of the client from column I and has to sum 100 total for one client. And it does without rounding the P values to 2 decimal places.
But for the accounting it is required to work with 2 decimal places and I can't figure it out at the moment how to make it sum 100% for every clients percentages in colum

Fusionista said:
As in the example file I have one client UMM sum the percentage to 100,08 in column P and the other client VAU has 99,99. So For UMM I should substract 0,08 from the values in column P and for VAU I would have to add 0,01 to column P somehow

i can't open the file. See my image above. And I'm not going to manually figure out how many rows of each number you have. Please copy paste a table.

Fusionista · Apr 17, 2024

CO Area	Company Code	Cycle	Text	Starting date	Ending date	Segment	Sender %	Client	Cost Element From	Cost Element To	WBS Element	Receiver %	Total h of every month	Total WBS	Unique value %	Total %
1000	1000	Z0423R	Text	01.04.2023	30.04.2023	Z0423RALS	100,00	ALS	410000	443333	XYLD01	3,69	3,69	3,69	100,00	100	0,00
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RUMM	100,00	UMM	410000	443333	200642	0,41		3,39	0,28
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RUMM	100,00	UMM	410000	443333	200643	0,41		3,39	0,28
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RUMM	100,00	UMM	410000	443333	200662	0,41		3,39	0,28
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RUMM	100,00	UMM	410000	443333	200665	0,41		3,39	0,28
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RUMM	100,00	UMM	410000	443333	200667	0,41		3,39	0,28
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RUMM	100,00	UMM	410000	443333	200670	0,41		3,39	0,28
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RUMM	100,00	UMM	410000	443333	200694	0,41		3,39	0,28
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RUMM	100,00	UMM	410000	443333	200700	0,41		3,39	0,28
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RUMM	100,00	UMM	410000	443333	200728	0,41		3,39	0,28
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RUMM	100,00	UMM	410000	443333	200736	0,41		3,39	0,28
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RUMM	100,00	UMM	410000	443333	200749	0,41		3,39	0,28
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RUMM	100,00	UMM	410000	443333	200751	0,41		3,39	0,28
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RUMM	100,00	UMM	410000	443333	200755	0,41		3,39	0,28
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RUMM	100,00	UMM	410000	443333	200772	0,41		3,39	0,28
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RUMM	100,00	UMM	410000	443333	200791	0,41		3,39	0,28
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RUMM	100,00	UMM	410000	443333	200857	0,41		3,39	0,28
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RUMM	100,00	UMM	410000	443333	200356	0,44		4,05	0,34
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RUMM	100,00	UMM	410000	443333	200389	0,44		4,05	0,34
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RUMM	100,00	UMM	410000	443333	200628	0,44		4,05	0,34
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RUMM	100,00	UMM	410000	443333	200632	0,44		4,05	0,34
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RUMM	100,00	UMM	410000	443333	200636	0,44		4,05	0,34
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RUMM	100,00	UMM	410000	443333	200654	0,44		4,05	0,34
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RUMM	100,00	UMM	410000	443333	200781	0,44		4,05	0,34
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RUMM	100,00	UMM	410000	443333	200784	0,44		4,05	0,34
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RUMM	100,00	UMM	410000	443333	200796	0,44		4,05	0,34
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RUMM	100,00	UMM	410000	443333	200797	0,44		4,05	0,34
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RUMM	100,00	UMM	410000	443333	200806	0,44		4,05	0,34
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RUMM	100,00	UMM	410000	443333	200810	0,44		4,05	0,34
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RUMM	100,00	UMM	410000	443333	200831	0,44		4,05	0,34
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RUMM	100,00	UMM	410000	443333	900648	0,83		4,11	0,34
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RUMM	100,00	UMM	410000	443333	900654	0,83		2,70	0,23
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RUMM	100,00	UMM	410000	443333	900657	0,83		4,11	0,34
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RUMM	100,00	UMM	410000	443333	200644	0,85		7,43	0,62
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RUMM	100,00	UMM	410000	443333	200646	0,85		7,43	0,62
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RUMM	100,00	UMM	410000	443333	200647	0,85		7,43	0,62
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RUMM	100,00	UMM	410000	443333	200648	0,85		7,43	0,62
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RUMM	100,00	UMM	410000	443333	200649	0,85		7,43	0,62
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RUMM	100,00	UMM	410000	443333	200650	0,85		7,43	0,62
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RUMM	100,00	UMM	410000	443333	200656	0,85		7,43	0,62
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RUMM	100,00	UMM	410000	443333	200657	0,85		7,43	0,62
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RUMM	100,00	UMM	410000	443333	200660	0,85		7,43	0,62
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RUMM	100,00	UMM	410000	443333	200676	0,85		7,43	0,62
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RUMM	100,00	UMM	410000	443333	200677	0,85		7,43	0,62
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RUMM	100,00	UMM	410000	443333	200678	0,85		7,43	0,62
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RUMM	100,00	UMM	410000	443333	200679	0,85		7,43	0,62
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RUMM	100,00	UMM	410000	443333	200681	0,85		7,43	0,62
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RUMM	100,00	UMM	410000	443333	200683	0,85		7,43	0,62
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RUMM	100,00	UMM	410000	443333	200684	0,85		7,43	0,62
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RUMM	100,00	UMM	410000	443333	200685	0,85		7,43	0,62
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RUMM	100,00	UMM	410000	443333	200686	0,85		7,43	0,62
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RUMM	100,00	UMM	410000	443333	200687	0,85		7,43	0,62
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RUMM	100,00	UMM	410000	443333	200691	0,85		7,43	0,62
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RUMM	100,00	UMM	410000	443333	200692	0,85		7,43	0,62
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RUMM	100,00	UMM	410000	443333	200696	0,85		7,43	0,62
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RUMM	100,00	UMM	410000	443333	200711	0,85		7,43	0,62
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RUMM	100,00	UMM	410000	443333	200712	0,85		7,43	0,62
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RUMM	100,00	UMM	410000	443333	200714	0,85		7,43	0,62
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RUMM	100,00	UMM	410000	443333	200733	0,85		7,43	0,62
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RUMM	100,00	UMM	410000	443333	200738	0,85		7,43	0,62
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RUMM	100,00	UMM	410000	443333	200740	0,85		7,43	0,62
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RUMM	100,00	UMM	410000	443333	200747	0,85		7,43	0,62
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RUMM	100,00	UMM	410000	443333	200756	0,85		7,43	0,62
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RUMM	100,00	UMM	410000	443333	200775	0,85		7,43	0,62
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RUMM	100,00	UMM	410000	443333	200776	0,85		7,43	0,62
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RUMM	100,00	UMM	410000	443333	200793	0,85		7,43	0,62
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RUMM	100,00	UMM	410000	443333	200801	0,85		7,43	0,62
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RUMM	100,00	UMM	410000	443333	200805	0,85		7,43	0,62
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RUMM	100,00	UMM	410000	443333	200814	0,85		7,43	0,62
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RUMM	100,00	UMM	410000	443333	200824	0,85		7,43	0,62
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RUMM	100,00	UMM	410000	443333	200830	0,85		7,43	0,62
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RUMM	100,00	UMM	410000	443333	200866	0,85		7,43	0,62
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RUMM	100,00	UMM	410000	443333	200096	1,01		10,14	0,85
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RUMM	100,00	UMM	410000	443333	200626	1,01		10,14	0,85
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RUMM	100,00	UMM	410000	443333	200637	1,01		10,14	0,85
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RUMM	100,00	UMM	410000	443333	200710	1,01		10,14	0,85
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RUMM	100,00	UMM	410000	443333	200720	1,01		10,14	0,85
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RUMM	100,00	UMM	410000	443333	200727	1,01		10,14	0,85
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RUMM	100,00	UMM	410000	443333	200734	1,01		10,14	0,85
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RUMM	100,00	UMM	410000	443333	200743	1,01		10,14	0,85
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RUMM	100,00	UMM	410000	443333	200752	1,01		10,14	0,85
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RUMM	100,00	UMM	410000	443333	200758	1,01		10,14	0,85
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RUMM	100,00	UMM	410000	443333	200779	1,01		10,14	0,85
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RUMM	100,00	UMM	410000	443333	200780	1,01		10,14	0,85
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RUMM	100,00	UMM	410000	443333	200786	1,01		10,14	0,85
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RUMM	100,00	UMM	410000	443333	200795	1,01		10,14	0,85
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RUMM	100,00	UMM	410000	443333	200802	1,01		10,14	0,85
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RUMM	100,00	UMM	410000	443333	200826	1,01		10,14	0,85
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RUMM	100,00	UMM	410000	443333	200827	1,01		10,14	0,85
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RUMM	100,00	UMM	410000	443333	220004	1,01		10,14	0,85
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RUMM	100,00	UMM	410000	443333	900612	1,52		5,32	0,44
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RUMM	100,00	UMM	410000	443333	900355A	2,34		9,41	0,78
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RUMM	100,00	UMM	410000	443333	900608	2,34		9,41	0,78
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RUMM	100,00	UMM	410000	443333	900620	2,34		9,41	0,78
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RUMM	100,00	UMM	410000	443333	900622	2,34		9,41	0,78
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RUMM	100,00	UMM	410000	443333	900623	2,34		9,41	0,78
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RUMM	100,00	UMM	410000	443333	900626	2,34		9,41	0,78
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RUMM	100,00	UMM	410000	443333	900628	2,34		9,41	0,78
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RUMM	100,00	UMM	410000	443333	900629	2,34		9,41	0,78
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RUMM	100,00	UMM	410000	443333	900369	13,66	100,00	517,27	43,11
1000	1000	Z0223R	Text	01.02.2023	28.02.2023	Z0223RUMM	100,00	UMM	410000	443333	900582	12,03		12,03	1,00	100,08	0,08
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RVAU	100,00	VAU	410000	443333	200078	0,65		11,18	0,93
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RVAU	100,00	VAU	410000	443333	200674	0,65		9,83	0,82
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RVAU	100,00	VAU	410000	443333	200700	0,65		9,83	0,82
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RVAU	100,00	VAU	410000	443333	200810	0,65		4,78	0,40
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RVAU	100,00	VAU	410000	443333	200874	0,65		4,78	0,40
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RVAU	100,00	VAU	410000	443333	200875	0,65		4,78	0,40
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RVAU	100,00	VAU	410000	443333	200877	0,65		4,78	0,40
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RVAU	100,00	VAU	410000	443333	200878	0,65		4,78	0,40
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RVAU	100,00	VAU	410000	443333	201027	0,65		9,83	0,82
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RVAU	100,00	VAU	410000	443333	201099	0,65		10,67	0,89
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RVAU	100,00	VAU	410000	443333	201204	0,65		9,83	0,82
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RVAU	100,00	VAU	410000	443333	201786	0,65		9,83	0,82
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RVAU	100,00	VAU	410000	443333	201788	0,65		4,78	0,40
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RVAU	100,00	VAU	410000	443333	202338	0,65		9,83	0,82
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RVAU	100,00	VAU	410000	443333	202414	0,65		9,83	0,82
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RVAU	100,00	VAU	410000	443333	202672	0,65		9,83	0,82
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RVAU	100,00	VAU	410000	443333	202803	0,65		4,78	0,40
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RVAU	100,00	VAU	410000	443333	RK04	0,65		9,83	0,82
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RVAU	100,00	VAU	410000	443333	200035	9,8		107,67	8,97
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RVAU	100,00	VAU	410000	443333	200794	9,8		107,67	8,97
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RVAU	100,00	VAU	410000	443333	201001	9,8		107,67	8,97
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RVAU	100,00	VAU	410000	443333	201010	9,8		107,67	8,97
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RVAU	100,00	VAU	410000	443333	201184	9,8		107,67	8,97
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RVAU	100,00	VAU	410000	443333	201913	9,8		107,67	8,97
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RVAU	100,00	VAU	410000	443333	201914	9,8		107,67	8,97
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RVAU	100,00	VAU	410000	443333	202102	9,8		107,67	8,97
1000	1000	Z0123R	Text	01.01.2023	31.01.2023	Z0123RVAU	100,00	VAU	410000	443333	202759	9,9	100,00	107,81	8,98
1000	1000	Z0323R	Text	01.03.2023	31.03.2023	Z0323RVAU	100,00	VAU	410000	443333	203217	8,26		85,99	7,17
1000	1000	Z1223R	Text	01.12.2023	31.12.2023	Z1223RVAU	100,00	VAU	410000	443333	201692	0,53		0,53	0,04
1000	1000	Z1223R	Text	01.12.2023	31.12.2023	Z1223RVAU	100,00	VAU	410000	443333	201778	0,53		0,53	0,04	99,99	0,01

Fusionista · Apr 17, 2024

Starts from A and "Unique value %" is column P

Fluff · Apr 17, 2024

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Rounding values to 2 decimel while keeping total 100%
There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

Fusionista · Apr 17, 2024

The link to my other post regarding this problem: Rounding values to 2 decimel while keeping total 100%

awoohaw · Apr 17, 2024

Fusionista said:
Starts from A and "Unique value %" is column P

i'm guessing the only real pertinent columns to your question are O and I?

Fusionista · Apr 17, 2024

Basically yes, and column O values come from the hours in column M "Receiver %"

awoohaw · Apr 17, 2024

As I look at this, why are you considering even rounding in column P? just format that column as .## but don't round.

awoohaw · Apr 17, 2024

Fusionista said:
Basically yes, and column O values come from the hours in column M "Receiver %"

and i've figured out column C matters, too.

Fusionista · Apr 17, 2024

Formatting doesn't change the fact that the values still have more than 2 decimal hidden. But I have to use 2 decimal places and somehow add/substract whatever is left to have 100% total

Rounding values to 2 decimel while keeping total 100%

Fusionista

New Member

awoohaw

Well-known Member

Excel Facts

Fusionista

New Member

Fusionista

New Member

Fluff

MrExcel MVP, Moderator

Fusionista

New Member

awoohaw

Well-known Member

Fusionista

New Member

awoohaw

Well-known Member

awoohaw

Well-known Member

Fusionista

New Member

Similar threads

Forum statistics

Share this page

Rounding values to 2 decimel while keeping total 100%

New Member

Well-known Member

Excel Facts

New Member

New Member

MrExcel MVP, Moderator

New Member

Well-known Member

New Member

Well-known Member

Well-known Member

New Member

Similar threads

Forum statistics

Share this page

We've detected that you are using an adblocker.

Which adblocker are you using?

Disable AdBlock

Disable AdBlock Plus

Disable uBlock Origin

Disable uBlock