Thread
:
+ or - ?
View Single Post
#
1
Posted to microsoft.public.excel.misc
M.A.Tyler
external usenet poster
Posts: 100
+ 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
Reply With Quote
M.A.Tyler
View Public Profile
Find all posts by M.A.Tyler