If cell = cell +/- 1.5

[Ctech]

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

[Ron Coderre]

If you want to test if A1 is EXACTLY A2 +/- 1.5 then try this:
=IF(OR(A2+1.5=A1,A2-1.5=A1),"YES","NO")

If you want to test is A1 is BETWEEN A2 +/- 1.5, then this may be what you want:
=IF(AND(A1>=A2-1.5,A1<=A2+1.5),"YES","NO")

Does that help?

Ron