怎么简化下面EXCEL公式

更新时间2019-12-08 05:18:01

怎么简化如下公式=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)