Thread: compare values
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected][_2_] RobcPettit@yahoo.co.uk[_2_] is offline
external usenet poster
 
Posts: 80
Default compare values

Hi, is it possible with vba, to compare values, give or take 1. eg x =
15 and y = 16. If x(+ or -1) = y(+ or -1) then............ In reality
what Ihave is something like 16.1111111 and 16.111112, I just want the
whole numbers, eg the 16, the .1111 is not needed, although its part of
the eqaution.
Regards Robert