The MOD function returns the remainder when two numbers are divided. For example, the formula =MOD(12,2) return the remainder 0. Syntax MOD(number, divisor) The function has the following arguments: number – Required. The number for which division is desired to get the remainder. divisor – Required. The number to be used for division. Example MOD […]

## MATCH function

The MATCH function looks up a value from an array and returns the relative position of the lookup value. For example, if the range B4:B6 contains the values 8,9 and 12 then the formula =MATCH(12,B4:B6,0) returns the relative position of 3 of the lookup value 12. Syntax The MATCH function has the following arguments: MATCH(lookup_value, […]

## Excel FORMULATEXT Function

FORMULATEXT function returns a text string from given reference containing a formula. Syntax FORMULATEXT(reference) The function has the following argument in the syntax: (reference) – Required. The reference to a cell/ range of cells, containing a formula. Example Error Occurs If #N/A The FORMULATEXT function is used on a reference that does not contain a […]

## Excel ROWS function

ROWS function returns the number of rows against a reference or array. For example, =ROWS(E5:E8) returns 4, because there 4 rows in the range. Syntax ROWS(array) The function has the following argument: array – Required. a reference, an array or range of cells for which number of rows needed. Example For more detail, visit Microsoft […]

## Excel HYPERLINK function

HYPERLINK function is used to access information quickly from another file or a web page. The link can be a text or a picture based. Syntax HYPERLINK (link_location, [friendly_name]) link_location – Required. The location of file or page to be opened. [friendly_name] – Optional. The name or text to display in a cell against the […]

## Excel ROW function

The ROW function returns the row number for a reference. For example, =ROW(B2) returns ‘2’ because B2 is the second row in the spreadsheet. Syntax ROW([reference]) Where [reference] is the optional argument. It is the cell reference or the range of cells for which you want row number. If omitted, Excel returns ROW number of […]

## Excel DATEVALUE Function

Sometimes, when you import data in Excel from an external source or enter a date in a cell that is formatted as text. In result, Excel keeps the date as text formatted and shows as left-aligned in a cell (instead of showing right-aligned). In case, if you do not change the text format, you may […]