IFS Function in Excel

Hello all. In this tutorial, let’s look at one of the new functions that’s available in Excel 2019 and 365 versions – IFS. IFS function is used to test multiple conditions and returns the first TRUE result. Unlike the IF function, IFS allows to test multiple conditions without nesting. Let’s look at the syntax andContinue reading “IFS Function in Excel”

IFERROR Function in Excel

Hello all. Let’s look at the IFERROR function in this tutorial. IFERROR function is used to trap errors and return a specific value for those error conditions. The function would trap the following errors: “#NA”, “#value!”, “#ref!”, “#div/0!”, “#num!”, “#Name?”, “#Null!” Syntax: =iferror(value, value_if_error) Here, the value can be a specific value or a referenceContinue reading “IFERROR Function in Excel”