excelk中,A2的数值怎样随着A1的数值改变自动数出不同的百分比?

2024-11-10 18:52:46
推荐回答(1个)
回答1:

=A1*LOOKUP(A1,{0,1}*10000,{8,10}%)
=A1*(8%+INT(A1/困碧10000)*2%)
=A1*IF(A1<汪闷举10000,8%,10%)
=A1*(10%-(A1<罩皮10000)*2%)