Friday, July 26, 2013

excel 挑选数据 的语句

=IF(OR(ABS(C2)>1,ABS(D2)>1),1,0)

挑选 C列或者D列 大于1的 行。满足条件的 标为1，不满足的标为 0
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)