请问excel有公式如果两个数相减的差在-1和1之间就返回0么？

如题

没有。但是你可以用IF 和 ABS 组合。

IF？

IF(ABS(A1-B1)<1,0,1) returns 0 if A1-B1 is between -1 and 1, and returns 1 otherwise. (Sorry my computer doesn't have Chinese input.)

楼上abs公式的那个返回值为1，不是0

回复 5楼luluyoga的帖子
The formula only gives 0 if |A1-B1|<1 (not including the cases when A1-B1=-1 or 1).
If you want to include -1 and 1, then you can use IF(ABS(A1-B1)<=1,0,1). It will return 0 if |A1-B1|<=1.

除以二取整

=INT(ABS(cellA-cellB))