View Single Post
 
Old 11-28-2016, 08:56 AM
xor xor is offline Windows 10 Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,100
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default

Try

=IF(ROUND(A3-SUM(B3:C3),2)=0,"-","check")

Change 2 to the precision you want.

The problem is the way that Excel represents values internally: 64-bit-binary floating-point. Values are represented by the sum of 53 consecutive powers of 2 ("bits") times an exponential factor. Consequently, most decimal fractions cannot be represented exactly.

If you really want to study this, see:

http://faculty.tarleton.edu/agapie/d...atingPoint.pdf
Reply With Quote