Error al multiplicar

%3CLINGO-SUB%20id%3D%22lingo-sub-3345411%22%20slang%3D%22es-ES%22%3EError%20multiplying%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3345411%22%20slang%3D%22es-ES%22%3E%3CP%3EI%20just%20found%20an%20error%20in%20Excel%20multiplication%2C%20I%20put%20this%20exercise%20to%20my%20son%20and%20while%20checking%20in%20Excel%20I%20found%20an%20error.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22WhatsApp%20Image%202022-05-09%20at%2012.10.21%20PM.jpeg%22%20style%3D%22width%3A%20534px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F370247i1A1FD396C1427406%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22WhatsApp%20Image%202022-05-09%20at%2012.10.21%20PM.jpeg%22%20alt%3D%22WhatsApp%20Image%202022-05-09%20at%2012.10.21%20PM.jpeg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3345411%22%20slang%3D%22es-ES%22%3E%3CLINGO-LABEL%3EExcel%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-3345881%22%20slang%3D%22en-US%22%3ERe%3A%20Error%20al%20multiplicar%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3345881%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1385112%22%20target%3D%22_blank%22%3E%40Fabiancho14%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EEl%20producto%20es%20demasiado%20grande%20para%20Excel.%20No%20puede%20mostrar%20m%C3%A1s%20de%2015%20d%C3%ADgitos%20con%20precisi%C3%B3n.%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fes-es%2Foffice%2Fespecificaciones-y-l%25C3%25ADmites-de-excel-1672b34d-7043-467e-8e27-269d656771c3%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EEspecificaciones%20y%20l%C3%ADmites%20de%20Excel%3C%2FA%3E%20%3A%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22S1420.png%22%20style%3D%22width%3A%20481px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F370271iC94B68840EFEBD73%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22S1420.png%22%20alt%3D%22S1420.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3346962%22%20slang%3D%22es-ES%22%3ERe%3A%20Error%20multiplying%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3346962%22%20slang%3D%22es-ES%22%3E%3CP%3Ethank%20you%20very%20much%20for%20the%20data%2C%20according%20to%20that%20what%20it%20does%20is%20round%20up%20the%20operations.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Acabo de encontrar un error en la multiplicación de Excel, puse este ejercicio a mi hijo y al verificar en Excel encontré un error. 

 

WhatsApp Image 2022-05-09 at 12.10.21 PM.jpeg

2 Replies

@Fabiancho14 

El producto es demasiado grande para Excel. No puede mostrar más de 15 dígitos con precisión.

Especificaciones y límites de Excel :

S1420.png

muchas gracias por el dato, según eso lo que hace es redondear las operaciones.