Formula getting .01 cent diffrence

%3CLINGO-SUB%20id%3D%22lingo-sub-2837162%22%20slang%3D%22en-US%22%3EFormula%20getting%20.01%20cent%20diffrence%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2837162%22%20slang%3D%22en-US%22%3E%3CP%3Ein%20the%20excel%20sheet%2C%20we%20are%20calculating%20cell%26nbsp%3B%3CSPAN%3E%2BC8-C28%20it's%20getting%20the%200.1%20cent%20difference%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E%3CSTRONG%3EExample%3C%2FSTRONG%3E%26nbsp%3B25%2C000.00-14%2C809.57%20%3D%20it%20should%20be%20return%2010%2C190.43%20but%20it%20is%20returning%2010%2C190.44%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3Ein%20our%20excel%20sheet%26nbsp%3B%2025%2C000.00%20in%20(C8)%20column%20and%26nbsp%3B14%2C809.57(C28)%20column%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3Eand%20we%20are%20using%20this%20formula%20to%20get%20the%20result%26nbsp%3B%2BC8-C28%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3Eplease%20help%20thanks%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2837162%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-2837252%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20getting%20.01%20cent%20diffrence%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2837252%22%20slang%3D%22en-US%22%3EIf%20C8%20and%20C28%20are%20cells%20which%20show%20the%20result%20of%20a%20calculation%20it%20is%20likely%20that%20those%20cells%20do%20not%20contain%20the%20EXACT%20values%20that%20you%20think%20they%20do.%20You'll%20have%20to%20explicitly%20round%20the%20numbers%20first%20before%20subtracting%20them%20to%20get%20an%20outcome%20as%20you%20might%20be%20expecting.%20Does%20this%20formula%20give%20you%20the%20expected%20outcome%3A%3CBR%20%2F%3E%3DROUND(C8%2C2)-ROUND(C28%2C2)%3C%2FLINGO-BODY%3E
Occasional Visitor

in the excel sheet, we are calculating cell +C8-C28 it's getting the 0.1 cent difference

Example 25,000.00-14,809.57 = it should be return 10,190.43 but it is returning 10,190.44

in our excel sheet  25,000.00 in (C8) column and 14,809.57(C28) column

and we are using this formula to get the result +C8-C28

 

please help thanks 

2 Replies
If C8 and C28 are cells which show the result of a calculation it is likely that those cells do not contain the EXACT values that you think they do. You'll have to explicitly round the numbers first before subtracting them to get an outcome as you might be expecting. Does this formula give you the expected outcome:
=ROUND(C8,2)-ROUND(C28,2)

@Twopir 

If you display more decimal places, you will most probably see that the values are not exactly 25,000.00 and 14,809.57. For example:

S0820.png

If it is essential to use the values with 2 decimal places, use

=ROUND(C8,2)-ROUND(C28,2)