100 | 100%Cotton | | =if(F14=100,"100%cotton",if(F14<95,"under 95%cotton",if(F14="0","other"),"1")) | 95 | Over 95%Cotton | | 如果F14=100,则显示100%cotton,如果95=<F14<100,则显示Over95%Cotton,
如果F14<95,则显示Under 95%Cotton,如果F14=0,则显示Other | 94 | Under 95%Cotton | | | 0 | Other | | | 用if 函数,但在要用 :如果95=<F14<100,则显示Over95%Cotton,时,该如何设置。TKS!
|