Adding tolerances to the EXACT formula

[TheSearch]

Hello everyone, new user here.

My problem is the following:

I have two sets of values, A (predicted) and B (actuals). At the moment I track the accuracy of my predictions with a simple EXACT formula, so for example we have

=EXACT(A;B)

As you know it returns TRUE if the values match and FALSE if they don't.

However, for the purposes of refining my forecast, being off by a few units isn't a critical flaw. How does one go about creating a similar function, but with a built-in range of tolerances in which the values still show a match?

In effect the intention is that A would still be TRUE if it equalled B, plus or minus, for example, five units.

I can’t seem to make any progress on this front.

Any help would be appreciated. Thanks in advance.

[DonkeyOte]

EXACT function is useful for case sensitive string comparisons (given most functions are case insensitive), however, for numerical comparisons EXACT is not really needed.

=ABS(A1-B1)<=5

[jawad1_ali]

To add to what Ote suggested, u need to use if statement to identify true ++ or false ++

[DonkeyOte]

u need to use if statement to identify true ++ or false ++

No you don't, the nature of the calculation is such that a Boolean value will result.

eg. =ABS(10-6)<=5 will return TRUE.

[jawad1_ali]

hey thats right..

Thanks..