Preventing Errors

A common method used to try and eliminate errors from appears on your worksheet is to use the ISERROR worksheet function as a wrapper.

alt text

The formula in cell B2 tries to divide D2 by D3, which generates an error as division by zero is not possible.
The formula in cell B3 includes the ISERROR function as a wrapper around the formula.



© 2022 Better Solutions Limited. All Rights Reserved. © 2022 Better Solutions Limited TopPrevNext