不同店铺请根据自己行业规则修改↓↓↓并且复制下面函数并加“=”号即可
R的函数:IF(B2<=90,5,IF(B2<=180,4,IF(B2<=360,3,IF(B2<=720,2,1))))
M的函数:IF(D2<=100,1,IF(D2<=200,2,IF(D2<=500,3,IF(D2<=1000,4,5))))