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.

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.

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