Forum Discussion
dudas
Hola buenas noches ,lo que sucede es que tengo un inconveniente y necesito su ayuda. realice una división , ella me arrojo estos valores € 361.486,486 € 304.054,054 cl...
mariavaquiro97 I suspect that both underlying numbers of your addition have decimals less than 0.50 and that the cells containing these numbers are formatted to display zero decimals. Hence, both numbers get "rounded down" to the nearest whole number for display purposes only. By summing the two numbers, the total will have a decimal greater or equal than 0.50 and, using the same formatting, will be "rounded up" to the nearest whole number. If you want to calculate with rounded numbers, you need to use the ROUND function (REDONDEAR in Spanish).
Perhaps best illustrated in the attached example.