# Workbook Functions T-Y

T(value)

Returns the value if it is a text.

Tangent of the angle (*180/PI to convert the angle from degrees to radians).

TANH(any number)

Hyperbolic tangent of a number.

TEXT(number, format)

Transforms the given number into text, using the specified formatting; e.g.: TEXT(34626.2, "MM/DD/YY") returns 10/19/94.

TIME(0<hour<23, 0<minute<59, 0<second<59)

Returns the serial number for the specified time.

TIMEVALUE(text)

Returns the serial number for the supplied time given in text format.

TODAY()

Returns the current date as a serial number.

TRIM(text)

Removes all spaces from text except single spaces between words.

TRUE()

Logical value TRUE.

TRUNC(number [, precision])

Truncates the given number to an integer, with the number of decimal places allowed in the truncated number given by precision (default is 0).

TYPE(expression)

Argument type of the given expression: 1 for numbers, 2 for text strings, 4 for logical values and 16 for error values.

UPPER(text)

Changes the characters in a text to uppercase characters.

VALUE(text)

Returns the specified text as a number.

VAR(number list)

Variance of a population based on a sample of values.

VARP(number list)

Variance of a population based on an entire population of values.

VDB(initial cost, salvage value, number of periods in useful life, start period, end period [, factor] [,method])

Depreciation of an asset for a specified period using a variable method of depreciation. Start period and end period are the beginning and end periods for which to calculate the depreciation. Factor is the rate at which the balance declines (default is 2) and method is a logical value that determines if the method to be used should be switched to straight-line method when the depreciation is greater than the declining balance calculation.

VLOOKUP(search item, search range, column index)

Compares the information in the first column of the search range to the supplied search item. When a match is found, information located in the same row and supplied column (column index) is returned.

WEEKDAY(serial number)

Day of the week that corresponds to the supplied date: Sunday is 1 and 7 is Saturday.

YEAR(serial number)

Year that corresponds to the supplied date.