excle中怎样通过函数找出一列数字小于六位的数?

2026-05-19 07:15:38
推荐回答(2个)
回答1:

=if(len(a2)<6,"少于6位","")

公式下拉

回答2:

如果A列为数值,可用如下公式
=IF(A2<100000,"小于6位","")


=IF(A2-100000<0,"小于6位","")

=IF(LEN(A2)<6,"小于6位","")