execl怎么处理B2=A2*X(如果A2

来源:学生作业帮助网 编辑:作业帮 时间:2024/04/29 12:28:08
execl怎么处理B2=A2*X(如果A2

execl怎么处理B2=A2*X(如果A2
execl怎么处理B2=A2*X(如果A2

execl怎么处理B2=A2*X(如果A2
=A2*(IF(A4150,A2200,A2250的时候怎么没有数值,如果有就把""改成要的数值就可以了

b2=IF(A2<=150,A2*0.1,IF(AND(A2<=200, A2>150),A2*0.2,IF(AND(A2<=250,A2>200),A2*0.3,A2&"超出范围!")))

=IF(A2<=150,A2*0.1,IF(A2<200,A2*0.02,A2*0.3))

=IF(A2<=150,A2*0.1,IF(A2<=200,A2*0.02,IF(A2<=250,A2*0.3,"数值超出250"))