B4是获取的总行数,如何实现当前行小于0.15,大于0.15小于0.45,大于0.45小于0.95,大于0.95小于1这四种情况分别给不同的值呢?
if((row()-2)/B4<=0.15,"20",if(and((row()-2)/B4>0.15,(row()-2)/B4<=0.45),"值1",if(and((row()-2)/B4>0.45,(row()-2)/B4<=0.95),"值2","值3")))
if((row()-2)/B4 <=0.15,"值1",if((row()-2)/B4>0.15 && (row()-2)/B4 <=0.45,"2",if((row()-2)/B4>0.45 && (row()-2)/B4 <=0.95,"3",if((row()-2)/B4>0.95 && (row()-2)/B4 <=1,"4","其他"))))
if((row()-2)*1.0/b4<=0.15,"值1",IF((row()-2)*1.0/b4<=0.45,"值2",IF((row()-2)*1.0/b4<=0.95,"值3","值4")))