Is there a way to make a formula or macro in excel which does this..

If Cell(A1) = Cell(A2) +/- 1.5 then write YES

Reason for needing this is that Vlookup function doesnt work, as there is a lot of decimal places.


Thanks