The Excel ISERROR function checks whether a value is an error. The function only returns TRUE upon finding an error and returns FALSE for all other values.ISERROR, which literally means 'Is error?', tests all types of Excel errors. Making its entry into the Excel world in 2003, ISERROR comes from a group of IS functions that results in TRUE or … [Read more...]
Excel WEEKDAY Function – How to Use
The WEEKDAY function is a DATE and TIME function that can be used to find the weekday for a given date. The date is supplied to the function as an argument, and consequently, the function returns an integer between 1 – 7, each number representing a day of the week. By default, 1 represents Sunday and 7 represents Saturday, but these values are … [Read more...]
Excel ISERR Function – How to Use
The Excel ISERR function checks whether a value is an error (except for the #N/A error) or not. The function returns TRUE upon finding any error except the #N/A. It returns FALSE for all other values and for #N/A errors.ISERR literally means ‘Is error?’, but by shortening the spelling, it hints that it would not work for #N/A errors. This may … [Read more...]
Excel ISNA Function – How To Use
The Excel ISNA function checks whether a value is #N/A or not. The function only returns TRUE upon finding the #N/A error. It returns FALSE for all other values or errors. The objective of the ISNA function is to solely recognize and handle #N/A errors and return TRUE when an #N/A error is found and FALSE for everything else.By #N/A here, we mean … [Read more...]
Excel EDATE Function – How To Use
The Excel EDATE function is categorized as a DATE and TIME function. It’s a handy function for when you want to calculate a date and number of months in the future or the past. You can use this function to compute the maturity of investments, accounts receivable, and due dates for any other purpose.SyntaxThe syntax of the EDATE function is … [Read more...]
Excel IFNA Function – How To Use
The Excel IFNA function is a logical function that returns the value specified if the expression resolves to #N/A, otherwise it returns the result of the expression. The purpose of this function is to handle #N/A results and show them in a custom manner instead of showing "#N/A".By #N/A here, we mean 'not available' and IFNA literally means 'If … [Read more...]
Excel NOT Function – How To Use
The Excel NOT function is categorized as a logical function. According to MS Excel, "The NOT function changes FALSE to TRUE, or TRUE to FALSE".What we’re saying is that the function results in the opposite outcome of its fed parameters. The NOT function is beneficial in the cases where we wish to verify if a specific condition was not met.We … [Read more...]
Excel OR Function – How To Use
Categorized as a logical function, the Excel OR function checks multiple conditions (passed as arguments) to verify whether any of the conditions turn out to be TRUE. The OR function in Excel either returns a TRUE or a FALSE. It returns FALSE only if all arguments evaluate to FALSE. The function returns TRUE even if a single argument evaluates to … [Read more...]
