![](https://s1.vip.wpscdn.cn/web-libs/image/learning-fe/cover/single_xls.png)
PHONETIC函数
链接非连贯的文本
![](https://s1.vip.wpscdn.cn/web-libs/image/learning-fe/cover/single_xls.png)
超级神秘的
CELL函数
![](https://s1.vip.wpscdn.cn/web-libs/image/learning-fe/cover/single_xls.png)
ISERROR函数
判断数值是否错误
![](https://s1.vip.wpscdn.cn/web-libs/image/learning-fe/cover/single_xls.png)
N函数将非数值
转换成数值
![](https://s1.vip.wpscdn.cn/web-libs/image/learning-fe/cover/single_xls.png)
ISNUMBER
一秒判断是否是数值
![](https://s1.vip.wpscdn.cn/web-libs/image/learning-fe/cover/single_xls.png)
ISBLANK函数
快速查看单元格空格
![](https://s1.vip.wpscdn.cn/web-libs/image/learning-fe/cover/single_xls.png)
巧用ISNA函数
处理错误值#N/A
![](https://s1.vip.wpscdn.cn/web-libs/image/learning-fe/cover/single_xls.png)
INFO函数
查询操作环境信息
![](https://s1.vip.wpscdn.cn/web-libs/image/learning-fe/cover/single_xls.png)
ISODD函数判断数值奇偶
![](https://s1.vip.wpscdn.cn/web-libs/image/learning-fe/cover/single_xls.png)
巧用TYPE函数
检验数值类型
![](https://s1.vip.wpscdn.cn/web-libs/image/learning-fe/cover/single_xls.png)
ISERR与IF
一步去除错误字符
![](https://s1.vip.wpscdn.cn/web-libs/image/learning-fe/cover/single_xls.png)
NA函数美化折线图
![](https://s1.vip.wpscdn.cn/web-libs/image/learning-fe/cover/single_xls.png)
ERROR.TYPE函数
![](https://s1.vip.wpscdn.cn/web-libs/image/learning-fe/cover/single_xls.png)
ISTEXT函数
检测参数是否为文本
![](https://s1.vip.wpscdn.cn/web-libs/image/learning-fe/cover/single_xls.png)
ISFORMULA函数
![](https://s1.vip.wpscdn.cn/web-libs/image/learning-fe/cover/single_xls.png)
ISREF函数判断
值是否为单元格引用
![](https://s1.vip.wpscdn.cn/web-libs/image/learning-fe/cover/single_xls.png)
巧用ISEVEN函数
判断数值是否偶数
![](https://s1.vip.wpscdn.cn/web-libs/image/learning-fe/cover/single_xls.png)
ISNONTEXT函数
检验值是否为非文本
![](https://s1.vip.wpscdn.cn/web-libs/image/learning-fe/cover/single_xls.png)
ISLOGICAL函数
检验逻辑值
![](https://s1.vip.wpscdn.cn/web-libs/image/learning-fe/cover/single_xls.png)
SHEETSNAME
函数的用法
![](https://s1.vip.wpscdn.cn/web-libs/image/learning-fe/cover/single_xls.png)