If you are working in a financial organization or in an accounting firm or a school and teach mathematics and needs to find the nth
Category: Excel
All Excel
Purpose: This function compares two text strings and results in TRUE and FALSE. The function matches 2 strings from 2 cells or 2 fixed values. Return
The Excel YEAR function returns the year component of a date as a 4-digit number. You can use the YEAR function to extract a year
MATCH is an Excel function used to locate the position of a lookup value in a row, column, or table. MATCH supports approximate and exact
The Excel ISNUMBER function returns TRUE when a cell contains a number, and FALSE if not. You can use ISNUMBER to check that a cell contains
The Excel WORKDAY function takes a date and returns the nearest working day n days in the future or past. You can use the WORKDAY
The Excel WEEKNUM function takes a date and returns a week number (1-54) that corresponds to the week of year. The WEEKNUM function starts counting
The Excel WEEKDAY function takes a date and returns a number between 1-7 representing the day of week. By default, WEEKDAY returns 1 for Sunday
The Excel SUBTOTAL function returns an aggregate result for supplied values. SUBTOTAL can return a SUM, AVERAGE, COUNT, MAX, and others (see table below), and
The Excel SEARCH function returns the location of one text string inside another. SEARCH returns the position of the first character of find_text inside within_text.