Oct 28 2020 06:44 PM
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 |
claramente esta suma termina en 0 ósea
€ 665.540,540 |
pero al momento de sumarlo en Excel debido a los decimales que tiene me da esto
€ 665.540,541 |
como puedo hacer para que esto no suceda y los datos sean correctos , que formula o configuración puedo realizar
Oct 28 2020 09:29 PM
@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.
Oct 29 2020 01:25 AM
So you want to add the number without the decimals
use INT()
if your numbers are in C2 and C3 then use INT(c2) +int(c3)
hope this is useful