dudas

%3CLINGO-SUB%20id%3D%22lingo-sub-1830427%22%20slang%3D%22es-ES%22%3EDoubts%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1830427%22%20slang%3D%22es-ES%22%3E%3CP%3EHello%20good%20night%20%2C%20what%20happens%20is%20that%20I%20have%20an%20inconvenience%20and%20I%20need%20your%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Emake%20a%20split%2C%20she%20threw%20me%20these%20values%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%20width%3D%22111%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%22111%22%3E%E2%82%AC361%2C486%2C486%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E304%2C054%2C054%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eclearly%20this%20sum%20ends%20in%200%20bone%3C%2FP%3E%3CTABLE%20width%3D%22111%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%22111%22%3E%E2%82%AC665%2C540%2C540%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ebut%20when%20I%20add%20it%20up%20in%20Excel%20because%20of%20the%20decimals%20you%20have%20give%20me%20this%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%20width%3D%22111%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%22111%22%3E%E2%82%AC665%2C540%2C541%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eas%20I%20can%20do%20so%20that%20this%20doesn't%20happen%20and%20the%20data%20is%20correct%2C%20what%20formula%20or%20configuration%20I%20can%20perform%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1830427%22%20slang%3D%22es-ES%22%3E%3CLINGO-LABEL%3EAdmin%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20mobile%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1830669%22%20slang%3D%22en-US%22%3ERe%3A%20dudas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1830669%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F849714%22%20target%3D%22_blank%22%3E%40mariavaquiro97%3C%2FA%3E%26nbsp%3BI%20suspect%20that%20both%20underlying%20numbers%20of%20your%20addition%20have%20decimals%20less%20than%200.50%20and%20that%20the%20cells%20containing%20these%20numbers%20are%20formatted%20to%20display%20zero%20decimals.%20Hence%2C%20both%20numbers%20get%20%22rounded%20down%22%20to%20the%20nearest%20whole%20number%20for%20display%20purposes%20only.%20By%20summing%20the%20two%20numbers%2C%20the%20total%20will%20have%20a%20decimal%20greater%20or%20equal%20than%200.50%20and%2C%20using%20the%20same%20formatting%2C%20will%20be%20%22rounded%20up%22%20to%20the%20nearest%20whole%20number.%20If%20you%20want%20to%20calculate%20with%20rounded%20numbers%2C%20you%20need%20to%20use%20the%20ROUND%20function%20(REDONDEAR%20in%20Spanish).%3C%2FP%3E%3CP%3EPerhaps%20best%20illustrated%20in%20the%20attached%20example.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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

2 Replies
Highlighted

@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.

Highlighted

@mariavaquiro97 

 

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