使用道具 举报
dehsz@126.com 发表于 2022-8-5 14:08 =IF(AND(A1="是",A2="沥青"),N1*N2,IF(AND(A1="是",A2="车行"),N3*N4,IF(AND(A1="是",A2="人行"),N5*N6,IF( ...
ljzy001 发表于 2022-8-5 14:12 谢谢,但不是括号和大小写的问题哈
hcm19522 发表于 2022-8-5 15:01 B2=IF(A$1="是",IFERROR(PRODUCT(N(OFFSET(N$1,MATCH(A2,{"沥青","车行","人行","砾石"},)*2-{2,1},))),"XX ...
本版积分规则 发表回复 回帖后跳转到最后一页
小黑屋|手机版|Archiver|Excel精英培训 ( 豫ICP备11015029号 )
GMT+8, 2024-4-19 04:00 , Processed in 0.435251 second(s), 11 queries , Gzip On, Yac On.
Powered by Discuz! X3.4
Copyright © 2001-2020, Tencent Cloud.