IF Function - Within Range

[jharvey87]

Hi Everyone!

Would someone mind please assisting with writing an if statement? Basically I'm trying to compare two numbres to see if they are equal. The issue I'm having is they don't need to be exact. Is it possible to write one thats within 1 or -1? So for example, IF S8=I14 and S8 = 10 and S8=9.50 it would return "True". Because of rounding, they're never exact. So basically having a margin of error within 1.

Any ideas on how I can do this?

[mo4391]

=IF(AND(S8>=I14-1,S8<=I14+1),"True","False")