• Data Validation – IS & IF

    With large amounts of data in Excel, it's particularly hard to see where errors might occur. ISERROR and IFERROR help identify where errors have occurred, with IFERROR also allowing you to deal with the error in the same function.