=if(len(a2)<6,"少于6位","")
公式下拉
如果A列为数值,可用如下公式=IF(A2<100000,"小于6位","")或=IF(A2-100000<0,"小于6位","")或=IF(LEN(A2)<6,"小于6位","")