Excel Formulas

Showing page 18 of 21
ISREF
Information

Returns TRUE if the value is a reference

ISTEXT
Information

Returns TRUE if the value is text

N
Information

Returns a value converted to a number

TYPE
Information

Returns a number indicating the data type of a value

CELL
Information

Returns information about the formatting, location, or contents of a cell

HYPERLINK
Lookup

Creates a shortcut or jump that opens a document stored on a network server, an intranet, or the Internet

INDEX
Lookup

Returns a value or the reference to a value from within a table or range

INDIRECT
Lookup

Returns a reference specified by a text string

LOOKUP
Lookup

Looks up values in a vector or array

MATCH
Lookup

Looks up values in a reference or array

OFFSET
Lookup

Returns a reference offset from a given reference

ROW
Lookup

Returns the row number of a reference

ROWS
Lookup

Returns the number of rows in a reference

TRANSPOSE
Lookup

Returns the transpose of an array

HLOOKUP
Lookup

Looks in the top row of an array and returns the value of the indicated cell

DATEDIF
Date

Calculates the number of days, months, or years between two dates

DATEVALUE
Date

Converts a date in the form of text to a serial number

DAY
Date

Converts a serial number to a day of the month

DAYS
Date

Returns the number of days between two dates

DAYS360
Date

Calculates the number of days between two dates based on a 360-day year

Page 18 of 21