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...]
Excel IFS Function – How To Use
The IFS function in Excel is a logical function that, in simplest terms, applies multiple IF functions. It allows the users to test a value against multiple conditions. The function accepts one or more conditions (or Boolean expressions) and a value to be returned against each condition.The result returned by the function is the value that … [Read more...]
Excel DAYS Function – How To Use
The DAYS function, categorized as a Date/Time function, is a worksheet (WS) function that allows us to compute the number of days between any two given dates. The DAYS function saw the light of day with MS Excel 2013, so if you are on an older version, you will need to rely on the DATEDIF function instead.SyntaxThe syntax of the DAYS function … [Read more...]
Excel DAY Function – How To Use
The DAY function has a simple purpose when used by itself. It gives you the "day" component (i.e., a number from 1-31) of a date inside a cell. However, the DAY function allows us to play around with dates in our worksheets by using it with some logical arguments or other functions, as will see in the examples section.But first, let's get some … [Read more...]
Excel DATEVALUE Function – How To Use
The DATEVALUE function serves a simple purpose. It converts a date written as a text string into a serial number that Excel can recognize. While it looks (and indeed is) pretty straightforward, the DATEVALUE function provides powerful ammunition for converting dates, which consequently enables us to manipulate them with formulas and pivot … [Read more...]
