Workbook Functions T-Y

 

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-2016 StatsDirect Limited, all rights reserved. Download a free trial here.