I'm using Excel to highlight differences in two outputs that should be the same. My problem is that even if they're different by a value of 0.001 (which is technically correct), I want to add a threshold that caters for small amounts like this. So if A1 and B1 are within 0.001 of each other, for example, then it's true. Any more than this and then it becomes false.
The cells are also being rounded so currently look like this:
Any help would be appreciated! Thanks.