What is the Excel YEAR Function? The Excel YEAR function returns the year corresponding to date as a 4-digit number starting from 1900 until 9999. Use the YEAR function to extract the year from a date into a cell. YEAR Syntax YEAR(serial_number) serial_number, required, a valid …
What is the Excel MONTH Function? The Excel MONTH function extracts the month number from a date, returns an integer number, ranging from 1 (January) to 12 (December). MONTH Syntax MONTH(serial_number) serial_number, required, a valid date in a format Excel recognizes. Usage Note: Excel returns a …
What is the Excel DAY Function? The DAY function returns integer numbers between 1 to 31 as the day of the months. Use the DAY function to extract a day number from a date. DAY Syntax DAY(serial_number) serial_number, required, a valid Excel date in serial number …
What is the Excel ISODD Function? The ISODD function is a function to check whether a number is odd or not, returns TRUE if the number is odd and FALSE if not. ISODD Syntax ISODD(number) number, required, the numeric value to test Usage Note: If the …
What is the Excel SUMIFS Function? The SUMIFS function is a SUMIF function with more than one criteria. This function available for Excel 2007 or newer version, an improvement of the SUMIF function that handles only one criterion. SUMIFS Syntax SUMIFS(sum_range, criteria_range1, criteria1, , ...) sum_range, …
What is the Excel SUMIF Function SUMIF is a function to add numbers within a range that meet single criteria. The criteria could be a number, text, or date, support for the logical operator (<, >, =, <>) and wildcard (?, *) for partial matching. SUMIF …
What is the Excel IFS Function? Excel IFS Function is an improvement of multiple IF statements. No need nested IF function to analyze more than two criteria, one IFS function is enough but with many logical_test. Unfortunately, this function is only available for those who subscribe …
What is Multiple IF Statements? Multiple IF statements are also known as “Nested IF Statement” is a formula containing 2 or more IF functions. A single IF function only analyze two criteria. If there are more than two criteria, then it should use the multiple IF …
What is the Excel IF Function? The IF function is a logical function to analyze a condition. If the condition met the criteria (TRUE) return value_if_true argument, otherwise (FALSE) return value_if_false argument. IF Syntax IF(logical_test, , ) logical_test (required), the condition you want to analyze, are …
