问题描述:
EXCEL表格中,小于60的数乘以10,大于等于60小于70的数乘以8,大于等于70的数乘以5 怎么表达?
A1是80,我在B1中输入下面两公式中任一个后,B1中都显示640,
"=IF((A1=60),A1*8,IF((A1>=70),A1*5)))"
或"=IF(AND(A1=60),A1*8,IF(AND(A1>=70),A1*5)))"
A1是80,我在B1中输入下面两公式中任一个后,B1中都显示640,
"=IF((A1=60),A1*8,IF((A1>=70),A1*5)))"
或"=IF(AND(A1=60),A1*8,IF(AND(A1>=70),A1*5)))"
问题解答:
我来补答展开全文阅读