![]() |
#3
|
|||
|
|||
![]()
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 |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Timing Doesn't Hold | yonargi2 | PowerPoint | 0 | 11-13-2015 03:15 PM |
![]() |
ohawiseguyeh | PowerPoint | 8 | 11-03-2014 11:15 PM |
![]() |
rarulkumar | Word VBA | 2 | 04-19-2013 03:19 AM |
slideshow doesn't run | gali | PowerPoint | 0 | 10-10-2010 11:39 PM |
Autotext screen tip doesn't appear | Steve_D | Word | 0 | 05-11-2010 07:14 PM |