怎么简化下面EXCEL公式
怎么简化如下公式=IFS(A2=1,H11,A2=2,H12,A2=3,H13,A2=4,H14,A2=5,H15,A2=6,H16,A2=7,H17,A2=8,H18,A2=9,H19,A2=10,H20,A2=11,H21,A2=12,H22)
=INDEX(H11:H22,A2)
=indirect("H"&10+A1)
=INDEX(H11:H22,A2)
=OFFSET(H10,,A2)
怎么简化下面excel公式昨天检举 玉国_041 3级 20次浏览
怎么简化如下公式=IFS(A2=1,H11,A2=2,H12,A2=3,H13,A2=4,H14,A2=5,H15,A2=6,H16,A2=7,H17,A2=8,H18,A2=9,H19,A2=10,H20,A2=11,H21,A2=12,H22)
下一篇:我看胡适母亲作文400字
热门标签: