假设是A1单元格为1或2或3时,另一单元格中分别对应乘以525或300或120自动求值。
则另一单元格写入公式
=IF(A1="","",A1*IF(A1=1,525,IF(A1=2,300,120)))
或
=IF(A1="","",A1*LOOKUP(A1,{1,2,3},{525,300,120}))
再或
=IF(A1="","",A1*CHOOSE(A1,525,300,120))
=IF(A1="","",A1*INDEX({525,300,120},A1))
温馨提示:答案为网友推荐,仅供参考