X>=200,比例为2%;100

问题描述:

X>=200,比例为2%;100

嵌套一下
=if(x>=200,0.02,if(x>=100,0.016,if(x>=50,0.014,if(x>=20,0.012,0.01))))