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.
￭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.
￭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.
支付宝扫一扫 
评论列表（196条）
测试