T(value)

Returns the value if it is a text.

See also: CELL, N, VALUE

TAN(angle in radians)

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

See also: ATANH, COSH, SINH, TAN

TANH(any number)

Hyperbolic tangent of a number.

See also: ATANH, COSH, SINH, TAN

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.

See also: DOLLAR, FIXED, T, VALUE

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

Returns the serial number for the specified time.

See also: HOUR, MINUTE, NOW, SECOND, TIMEVALUE

TIMEVALUE(text)

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

See also: HOUR, MINUTE, NOW, SECOND, TIME

TODAY()

Returns the current date as a serial number.

See also: DATE, DAY, NOW

TRIM(text)

Removes all spaces from text except single spaces between words.

See also: CLEAN, MID, REPLACE, SUBSTITUTE

TRUE()

Logical value TRUE.

See also: FALSE

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).

See also: CEILING, FLOOR, INT, MOD, ROUND

TYPE(expression)

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

See also: ISBLANK, ISERR, ISERROR, ISLOGICAL, ISNA, ISNONTEXT, ISNUMBER, ISREF, ISTEXT

UPPER(text)

Changes the characters in a text to uppercase characters.

See also: LOWER, PROPER

VALUE(text)

Returns the specified text as a number.

See also: DOLLAR, FIXED, TEXT

VAR(number list)

Variance of a population based on a sample of values.

See also: STDEV, STDEVP, VARP

VARP(number list)

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

See also: STDEV, STDEVP, VAR

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.

See also: DDB, SLN, SYD

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.

See also: HLOOKUP, INDEX, LOOKUP, MATCH

WEEKDAY(serial number)

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

See also: DAY, NOW, TEXT, TODAY

YEAR(serial number)

Year that corresponds to the supplied date.

See also: DAY, NOW, HOUR, MINUTE, MONTH, SECOND, TODAY, WEEKDAY

Copyright © 2000-2019 StatsDirect Limited, all rights reserved. Download a free trial here.