Sum issue while increasing the decimals

%3CLINGO-SUB%20id%3D%22lingo-sub-2836777%22%20slang%3D%22en-US%22%3ESum%20issue%20while%20increasing%20the%20decimals%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2836777%22%20slang%3D%22en-US%22%3E%3CP%3EIn%20the%20below%20example%2C%20under%20H%20column%20(Yellow)%20-%20business%20user%20is%20increasing%20the%20decimals%20and%20then%20identified%20value%201%20coming%20up%20while%20summing%20up%20two%20values.%20In%20the%20same%20way%20under%20K%20column%20there%20is%20no%20value%201%20coming%20in%20the%20middle%20while%20summing%20up%20two%20values.%20User%20is%20asking%20for%20the%20justification.%20Is%20this%20any%20bug%20related%20to%20H%20column%20value%3F%3F%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Sum%20-%20Excel%20Issues%20H%20%26amp%3B%20K%20Columns.PNG%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F316681iD9AC54EB904CB69C%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Sum%20-%20Excel%20Issues%20H%20%26amp%3B%20K%20Columns.PNG%22%20alt%3D%22Sum%20-%20Excel%20Issues%20H%20%26amp%3B%20K%20Columns.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2836777%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2845941%22%20slang%3D%22en-US%22%3ERe%3A%20Sum%20issue%20while%20increasing%20the%20decimals%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2845941%22%20slang%3D%22en-US%22%3EThis%20is%20well-known%20and%20well-documented%20behavior%20of%20Excel%20(and%20other%20software)%3A%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Foffice%2Ftroubleshoot%2Fexcel%2Ffloating-point-arithmetic-inaccurate-result%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Foffice%2Ftroubleshoot%2Fexcel%2Ffloating-point-arithmetic-inaccurate-result%3C%2FA%3E%3C%2FLINGO-BODY%3E
New Contributor

In the below example, under H column (Yellow) - business user is increasing the decimals and then identified value 1 coming up while summing up two values. In the same way under K column there is no value 1 coming in the middle while summing up two values. User is asking for the justification. Is this any bug related to H column value??

Sum - Excel Issues H & K Columns.PNG

1 Reply
This is well-known and well-documented behavior of Excel (and other software): https://docs.microsoft.com/en-us/office/troubleshoot/excel/floating-point-arithmetic-inaccurate-resu...