Thread: + or - ?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
M.A.Tyler M.A.Tyler is offline
external usenet poster
 
Posts: 100
Default + or - ?

=IF(A1=B1,TRUE,FALSE), easy enough, but how about A1 being within .5 of B1?
In other words if B1=5, the statement would be true if A1=anywhere from 4.5
- 5.5.

is there a way to write this formula?

Thanks!

M.A.Tyler