使用道具 举报
by201 发表于 2013-12-12 13:30 当a2由a或b修改为空时,在c2也要显示为空,=IF(A2="","",IF(A2=B2,1,-1)),=if(a2="",c2="",if(a2=b2,1,-1) ...
本版积分规则 发表回复 回帖后跳转到最后一页
小黑屋|手机版|Archiver|Excel精英培训 ( 豫ICP备11015029号 )
GMT+8, 2024-5-17 16:10 , Processed in 0.100178 second(s), 8 queries , Gzip On, Yac On.
Powered by Discuz! X3.4
Copyright © 2001-2020, Tencent Cloud.