使用道具 举报
zhc3288 发表于 2014-9-20 11:28
李建军 发表于 2014-9-20 13:05 =IFERROR(LOOKUP(((A1+B1-C1^2-D1)*(A1+C1)/(A1-D1))*B1+C1,{0,100,1001},{10,15,9}),"负")
查看全部评分
baksy 发表于 2014-9-20 13:57 =TEXT(TEXT(((A1+B1-C1^2-D1)*(A1+C1)/(A1-D1))*B1+C1,"[
本版积分规则 发表回复 回帖后跳转到最后一页
小黑屋|手机版|Archiver|Excel精英培训 ( 豫ICP备11015029号 )
GMT+8, 2024-4-25 02:30 , Processed in 0.369235 second(s), 13 queries , Gzip On, Yac On.
Powered by Discuz! X3.4
Copyright © 2001-2020, Tencent Cloud.