1.若D10的值是（X-Y）形式，用下列公式：=IF(AND(VALUE(LEFT(D10,3))=0.7),"特细",IF(AND(VALUE(LEFT(D10,3))=1.6),"细砂",IF(AND(VALUE(LEFT(D10,3))=2.3),"中砂","越界")))2.若D10的值是具体的一个数值，如：0.9 则公式为：=IF(AND(D10=0.7),"特细",IF(AND(D10=1.6),"细砂",IF(AND(D10=0.7,D10=1.6,D10=2.3,D10<=3),"中砂","")))...
|
