excel之家吧 关注:156贴子:206
  • 1回复贴,共1
=IF(3.1=<U65=<3.7,"粗",=IF(2.3=<U65=<3.0,"中",=IF(1.6=<U65=<2.2,"细",=IF(0.7=<U65=<1.5,"特细","其他"))))
这个公式问题在哪,求教


1楼2016-09-05 16:03回复
    =IF(U65<=3.7,IF(U65<=3,IF(U65<=2.2,IF(U65<=1.5,IF(U65<0.7,"其他","特细"),"细"),"中"),"粗"))


    来自Android客户端2楼2016-09-29 08:24
    回复