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...]

Excel AND Function – How To Use

The AND function in Excel is a logical function that checks whether all arguments fed into the function are TRUE and returns "TRUE" if all arguments are TRUE. This implies that even one unmet condition will return "FALSE" as the result.Making its way into Excel in 2003, the AND function serves little functioning on its own.; though it is helpful … [Read more...]

Excel SWITCH Function – How To Use

The SWITCH function in MS Excel is a logical function used to compare one value (or the result of an expression) against a list of values and returns the first exact match found as a result.If there is no matching value found, the SWITCH function can return an optional default value. SWITCH function can only be found in Excel 2019 or later … [Read more...]

Excel EOMONTH Function – How To Use

The EOMONTH function, categorized as a Date/Time function, is a worksheet (WS) function that allows us to find the last date of a month after adding/subtracting 'n' months to/from any given date.Financial analysts often use the EOMONTH function to calculate maturities for the firm’s accounts payable or accounts receivable.SyntaxThe … [Read more...]

Excel CHOOSE Function – How To Use

The CHOOSE function in MS Excel returns a value from a list of values based on an index number. The list of values can also be specified as cell references. Choose function can support up to 254 values.Although on its own CHOOSE function may not look much valuable, but when combined with other functions, it can work wonders. The function has … [Read more...]

How to Convert Text or Numbers To Dates in Excel

Let’s say you have an organization that makes hundreds of small transactions each day. You have several branches where the junior accountant punches in the numbers and dates into different software. It’s finally the end of the month, and you want to look at where you stand compared to the previous month.This will require that you draw a gazillion … [Read more...]