X为A列，Y为B列 当X=100%，Y=15； 90%≤X=90),RANDBETWEEN(10,15),IF(AND(A1=80),RANDBETWEEN(2,10),IF(A1=100%, 15, IF(AND(A1>=90%, A1=80%, A1=0.9),RANDBETWEEN(10,15),IF(AND(A1=0.8),RANDBETWEEN(2,10),IF(A1<0.8,0,""))))这是转化为百分比的公示 大佬, 公式
