View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Aaron Aaron is offline
external usenet poster
 
Posts: 287
Default how do i set formula to be equal to a value plus or minus 1?

i want an if then statement. i have it now so that something happens if x =
y. well, i want the same thing to happen if x = y plus or minus 1. i found
that x is often within .1 or 1 of y and that is close enough for me to want
the something to happen. thanks.