Apple Numbers '08 Bedienungsanleitung PDF herunterladen (Seite 271)

Chapter 12 Dictionary of Functions 271

SECOND

The SECOND function extracts the seconds from a date.

SECOND(datetime)

Â date-time: Any valid Numbers date or time value.

SIGN

The SIGN function returns 1 when the argument number is positive, –1 when it is

negative, and 0 when it is zero.

SIGN(number)

Â number: The number you want to find the sign of. It can be a reference to a cell

containing a number.

SIN

The SIN function calculates the sine of an angle in radians.

SIN(radian-angle)

Â radian-angle: The 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 SIN 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

SEARCH("ra", "abracadabra") returns 3; the first occurrence of the string "ra" starts at the third

character in "abracadabra".

SEARCH("ra", "abracadabra", 5) returns 10, the position of the first occurrence of string "ra" when you

start looking at position 5.

Examples

SECOND("4/6/88 11:59:22 AM") returns 22.

Examples

SIGN(2) returns 1.

SIGN(0) returns 0.

SIGN(-2) returns -1.

SIGN(A4) returns -1 if cell A4 contains -2.

1 2 ... 266 267 268 269 270 271 272 273 274 275 276 ... 294 295

Keine Kommentare

Apple Numbers '08 Bedienungsanleitung Seite 271