A1数字 如大于等于20小于30 则在B1中A1*0.2 如大于等于30小于60 则在B1中A1*0.25 如大于等于60小于100 则在

题目

A1数字 如大于等于20小于30 则在B1中A1*0.2 如大于等于30小于60 则在B1中A1*0.25 如大于等于60小于100 则在

答案

=LOOKUP(A1,{0,20,30,60,100},{0,0.2,0.25,0.3,0.35})*A1