..........作者: 风过无息 时间: 2007-5-31 22:09
自己写个方法实现就好了作者: howard 时间: 2007-6-1 05:08 标题: 回复 #3 风过无息 的帖子 This is exactly what "IF" function does.
IF(logical_test,value_if_true,value_if_false)
C2:=IF(B1=B2,1,0)
C4:=IF(B3=B4,1,0)
...
You can copy and paste the formula to where ever you want it to be.作者: howard 时间: 2007-6-1 05:10 标题: 回复 #1 happy-sunny 的帖子 This is exactly what "IF" function does.
IF(logical_test,value_if_true,value_if_false)
C2:=IF(B1=B2,1,0)
C4:=IF(B3=B4,1,0)
...
You can copy and paste the formula to where ever you want it to be.