excel 函数，斑竹来看哈，

来源：百度知道 编辑：UC知道 时间：2024/05/27 14:00:07
用IF公式和那个公式组合，判断A1单元格内的数值是否为汉字，

=IF(A1="","空",IF(ISERROR(A1/1),"汉字","数值"))

=IF(LENB(A1)=LEN(A1)*2,"汉字",IF(ISERROR(A1*1)=FALSE,"数字","英文"))

=IF(ISNA(A1),"#N/A",IF(LENB(A1)=LEN(A1)*2,"汉字",IF(ISERROR(A1*1)=FALSE,"数字","英文")))

=IF(ISBLANK(A1),"空单元格",IF(ISERROR(SEARCHB("?",A1)),"纯汉字",IF(ISNUMBER(A1),"纯数字","由汉字,英文,数字等组合的文本")))