Apple Numbers '08 User Manual

Page 280

Advertising
background image

280

Chapter 12

Dictionary of Functions

T

The T function retrieves text from a cell. If the cell doesn’t contain a string, T returns an
empty string.

T(cell)

 cell: A reference to the cell from which you want to retrieve text.

Notes
This function is included so you can use spreadsheets created with older spreadsheet
applications that might use it.

TAN

The TAN function calculates the tangent of an angle, the ratio of the sine to the cosine.

TAN(radian-angle)

 radian-angle: An angle in radians.

Notes
If you measure angles in degrees instead of radians, you can use the RADIANS function
to convert degrees to radians for the TAN function.

If you want to express radians as a multiple of pi, you can use the PI() function to
provide a value for pi.

Examples

If cell A1 contains "text" and cell B1 is empty:

T(A1) returns "text" and T(B1) returns nothing.

Examples

TAN(1) returns 1.557407725, the tangent of 1 radian (approximately 57.3 degrees).

TAN(RADIANS(45)) returns 1, the tangent of a 45-degree angle.

TAN(3*PI()/4) returns -1.

Advertising