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.