Apple numbers User Manual

 Dictionary of Functions

 

  

The SECOND function extracts the seconds from a date.

SECOND(datetime)

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

  

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.

  

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.

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.

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

SIGN(2) returns 1.

SIGN(0) returns 0.

SIGN(-2) returns -1.

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