Grammar
ISERROR(value)
Detects whether a value is an error value and returnsTRUEOrFALSE.
Remarks
Value: The value to be detected can be a cell, formula, or numerical name.
Returns if the expression parameter indicates an error True; Otherwise, it returnsFalse.
In work and life We often need to detect whether there are errors in the data in a certain table. Let me teach you a little trick.
How to use the ISERROR function in the WPS 2019 EXCEL table to quickly detect whether there are errors in values.
Take this driving timetable as an example.
![微信截图_20190508144044.png 微信截图_20190508144044.png](https://font2020.oss-cn-beijing.aliyuncs.com/wps/images/eeaee2e3e4aef2fdf082fd03ea9c03b0.png)
![分界线.png 分界线.png](https://font2020.oss-cn-beijing.aliyuncs.com/wps/images/bccf8f501a092ee62d67745e209abab1.png)
■Place the cursor at (D3) and click Insert Function-Information-ISERROR Function.
A dialog box will pop up with one parameter.
"Value" is the data that needs to be detected. If the data is wrong, "True" will be returned; otherwise, "False" will be returned.
![巧用ISERROR函数判断数值是否错误1.gif 巧用ISERROR函数判断数值是否错误1.gif](https://font2020.oss-cn-beijing.aliyuncs.com/wps/images/0b338d7df1fab85cbb8f609353dea089.gif)
■We enter B3/C3 (B3 divided by C3) in "Value", which means to detect whether "driving 500 kilometers in 3 hours" is Wrong value.
Click "OK" and return "False", which means "driving 500 kilometers in 3 hours" is correct.
Position the cursor to the lower right corner of cell (D3), pull down and copy the formula when it is in a + shape, and you can determine whether all values have errors.
![巧用ISERROR函数判断数值是否错误2.gif 巧用ISERROR函数判断数值是否错误2.gif](https://font2020.oss-cn-beijing.aliyuncs.com/wps/images/52be525e6ee8d7efd01de3f84174290a.gif)
评论列表(196条)
测试