Getting an Integer Number that is part of a precise sum

Hello everyone,

I'm experiecing a difficulty with excel that probably is very easy to solve for any of you.
I've tried to search for answers but i didn't find the right solution to my problem.

I'm applying some complicate formulas in a column that are returning a number.
The formula is the same for each cell. These cells are summed in a final cell.

I would like to have in each cell an integer that can be exactly summed with the others in the last cell, not a number with decimals.

For example, if the sum is 10 and i have summed 5 cells, i would like to have 5 in the first, 2 in the second, 3 in the third and in the last 2 0.
At the moment, when the sum is 10 i have 3.2 in the first, 2.5 in the second etc.

Round function is not helping cause it just formats the number, it doesn't transform it in a true integer.

Thank you in advance,

Albertz

Instead of using the Round function, why not try using Int function instead? Maybe you can post your workbook?

Originally Posted by FDibbins

Hi, welcome to the forum



Not so, round physically changes the cell contents, not the formatting.

The table blow shows the affect of ROUND() using different decimals, all cells are formatted to 4 decimal places to show the difference

	A	B	C	D	E	F
1		Round 0	Round 1	Round 2	Round 3	Round 4
2	1.1	1.0000	1.1000	1.1000	1.1000	1.1000
3	2.22	2.0000	2.2000	2.2200	2.2200	2.2200
4	3.333	3.0000	3.3000	3.3300	3.3330	3.3330
5	4.4444	4.0000	4.4000	4.4400	4.4440	4.4444

Hi Ford,

thank you for your answer.
Yes, you're right. Round gives me an integer. However, i still need that the sum of those integers is exactly the one i have already.

I cannot post the workbook cause it is work related stuff.
Thank you for helping.