If cell = cell +/- 1.5
 

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 ther
is a lot of decimal places.


Thank

--
Ctec
-----------------------------------------------------------------------
Ctech's Profile: http://www.excelforum.com/member.php...fo&userid=2774
View this thread: http://www.excelforum.com/showthread.php?threadid=48819

If cell = cell +/- 1.5
 

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

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

Does that help?

Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=488199