|
|
|
|
|
|
|
Function |
|
Description |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
ABS |
|
Calculates the absolute value of a number. |
|
|
|
|
ACOS |
|
Calculates the arc cosine (inverse of cosine). |
|
|
|
|
ALERT |
|
Displays a message in a dialog box. |
|
|
|
|
AND |
|
Evaluates multiple values and returns TRUE if all are true or FALSE if any is false. |
|
|
|
|
ASIN |
|
Calculates the arc sine (inverse of sine). |
|
|
|
|
ATAN |
|
Calculates the arc tangent (inverse of tangent). |
|
|
|
|
ATAN2 |
|
Calculates the angle between the positive X-axis and a line starting at the origin (0,0) and passing through the x and y coordinates you specify. |
|
|
|
|
AVERAGE |
|
Calculates the average of a set of numbers. |
|
|
|
|
BASETONUM |
|
Converts a number in a specified base into a number in base 10. |
|
|
|
|
BEEP |
|
Plays the computer's alert sound. |
|
|
|
|
CHAR |
|
Returns the ASCII character corresponding to a specified value. |
|
|
|
|
CHOOSE |
|
Returns the value specified from a list of values (up to 250 characters). |
|
|
|
|
CODE |
|
Returns the numeric ASCII code that represents the first character in the specified text. |
|
|
|
|
COLUMN |
|
Returns the column number of the current cell or the cell referred to. |
|
|
|
|
CONCAT |
|
Joins (concatenates) strings of text. |
|
|
|
|
COS |
|
Calculates the cosine of a number. |
|
|
|
|
COUNT |
|
Returns the number of arguments given. |
|
|
|
|
COUNT2 |
|
Reads the first value in a list and returns the number of times that value appears in the list of remaining values. |
|
|
|
|
DATE |
|
Calculates a serial number for the specified date. |
|
|
|
|
DATETOTEXT |
|
Converts a date to text from the supplied serial number and format. |
|
|
|
|
DAY |
|
Returns the day of the month represented by a date serial number. |
|
|
|
|
DAYNAME |
|
Converts a number (1-7) to the name of the day of the week. |
|
|
|
|
DAYOFYEAR |
|
Converts a date serial number to the day of the year (1-366). |
|
|
|
|
DEGREES |
|
Converts the number of radians to an angle in degrees. |
|
|
|
|
ERROR |
|
Returns the value ERROR! |
|
|
|
|
EXACT |
|
Returns TRUE if two sets of specified text are identical. |
|
|
|
|
EXP (Exponent) |
|
Calculates e to the specified power. |
|
|
|
|
FACT |
|
Calculates the factorial of a number. |
|
|
|
|
FIND |
|
Searches for specified text in a list. |
|
|
|
|
FRAC |
|
Calculates the fractional part of a real number. The result is always positive. |
|
|
|
|
FV |
|
Calculates the future value of an investment and a series of added payments. |
|
|
|
|
HLOOKUP (Horizontal Lookup) |
|
Searches for a specific value in the top row of a range of cells. |
|
|
|
|
HOUR |
|
Converts the time portion of a serial number to the number of the hour (0-23). |
|
|
|
|
IF |
|
Returns a specified value depending on whether the expression is true or false. |
|
|
|
|
INDEX |
|
Returns the value of a specified cell within a range of cells. |
|
|
|
|
INT |
|
Returns the integer equal to or less than the value of the specified number. |
|
|
|
|
IRR |
|
Calculates an approximate internal rate of return on an investment and a series of cash flows. |
|
|
|
|
ISBLANK |
|
Determines whether an expression is blank (TRUE) or contains a number or text (FALSE). |
|
|
|
|
ISERROR |
|
Determines whether an error has occurred in evaluating an expression. |
|
|
|
|
ISLOGICAL |
|
Determines whether the value, operation, or equation in the argument can be evaluated as true or false. |
|
|
|
|
ISNA
(Is Not Available) |
|
Tests the contents of a cell for the #NA! error condition and returns TRUE if it finds this error. |
|
|
|
|
ISNUMBER |
|
Determines whether an expression is a number. |
|
|
|
|
ISTEXT |
|
Determines whether an expression is text. |
|
|
|
|
LEFT |
|
Extracts the first part of text in a field. |
|
|
|
|
LEN (Length) |
|
Counts the number of characters in the specified text, including spaces, numbers, and special characters. |
|
|
|
|
LN
(Natural Log) |
|
Calculates the natural logarithm of a number. |
|
|
|
|
LOG |
|
Calculates the logarithm of a number to a base. |
|
|
|
|
LOG10 |
|
Calculates the logarithm of a number to base 10. It's the inverse of the number E in scientific notation. |
|
|
|
|
LOOKUP |
|
Searches for a specific value in a range of cells. |
|
|
|
|
LOWER |
|
Converts uppercase characters in text to lowercase. |
|
|
|
|
MACRO |
|
Plays the specified AppleWorks macro or executes the specified button or AppleScript. |
|
|
|
|
MATCH |
|
Searches for a specific value in a range of cells, from left to right and top to bottom. |
|
|
|
|
MAX |
|
Returns the largest number in a list. |
|
|
|
|
MERGEFIELD |
|
Merges data from an AppleWorks database into an AppleWorks spreadsheet. |
|
|
|
|
MID (Middle) |
|
Extracts part of the text in a field, starting with a specified position and continuing a specified number of characters. |
|
|
|
|
MIN |
|
Returns the smallest number in a list. |
|
|
|
|
MINUTE |
|
Calculates minutes for a serial number. |
|
|
|
|
MIRR |
|
Calculates the modified internal rate of return of a series of cash flows. |
|
|
|
|
MOD (Modulo) |
|
Calculates the remainder when one number is divided by another. |
|
|
|
|
MONTH |
|
Returns the number of the month represented by a date serial number. |
|
|
|
|
MONTHNAME |
|
Converts a month's number (1-12) to its name. |
|
|
|
|
NA (Not Available) |
|
Returns the error value N/A! |
|
|
|
|
NOT |
|
Evaluates a logical value or expression and returns its opposite. The argument must be numeric. |
|
|
|
|
NOW |
|
Calculates and displays the current date and time. |
|
|
|
|
NPER (Number of periods) |
|
Calculates the number of periods of an investment involving constant cash flows. |
|
|
|
|
NPV |
|
Calculates the net present value of an investment. |
|
|
|
|
NUMTOBASE |
|
Converts a number in base 10 into another base. |
|
|
|
|
NUMTOTEXT |
|
Converts a number to a textual representation so that the number won't be included in calculations or charts. |
|
|
|
|
OR |
|
Evaluates multiple values and returns TRUE if any is true or FALSE if all are false. |
|
|
|
|
PI |
|
Supplies the value of pi (the ratio of a circle's circumference to its diameter). |
|
|
|
|
PMT |
|
Calculates payments given the interest rate, number of periods, preset value, future value, and type of payment. |
|
|
|
|
PRODUCT |
|
Calculates the product of the numbers in a list. |
|
|
|
|
PROPER |
|
Capitalizes the first character of each specified word. |
|
|
|
|
PV |
|
Calculates the present value of an investment. |
|
|
|
|
RADIANS |
|
Converts the number of degrees to radians. |
|
|
|
|
RAND |
|
Generates a random number. |
|
|
|
|
RATE |
|
Calculates the interest rate required for a present value to grow to a specified value when compounded over a given term. |
|
|
|
|
REPLACE |
|
Replaces text with new text, starting from a specified position. |
|
|
|
|
REPT |
|
Repeats text the specified number of times. |
|
|
|
|
RIGHT |
|
Extracts the last part of text in a field. |
|
|
|
|
ROUND |
|
Returns a number rounded to a specified number of digits. |
|
|
|
|
ROW |
|
Returns the row number of the specified cell. |
|
|
|
|
SECOND |
|
Calculates the seconds for a serial number. |
|
|
|
|
SIGN |
|
Returns 1 when the specified number is positive, -1 when it is negative, and 0 when it is zero. |
|
|
|
|
SIN |
|
Calculates the sine of a number, where the specified number is the angle in radians. |
|
|
|
|
SQRT |
|
Calculates the square root of a number. |
|
|
|
|
STDEV |
|
Calculates the standard deviation of a population based on a sample set of numbers. |
|
|
|
|
SUM |
|
Adds the numbers in a list. |
|
|
|
|
TAN |
|
Calculates the tangent of a number, where the number is the angle in radians. |
|
|
|
|
TEXTTODATE |
|
Converts a date written in text to its serial number. |
|
|
|
|
TEXTTONUM |
|
Converts text to a number (for functions that require a numeric argument). |
|
|
|
|
TEXTTOTIME |
|
Converts a time written in text to its serial number. |
|
|
|
|
TIME |
|
Converts a specified time (based on a 24-hour clock) to a serial number. |
|
|
|
|
TIMETOTEXT |
|
Converts a time serial number to text. |
|
|
|
|
TRIM |
|
Removes extra spaces from text. |
|
|
|
|
TRUNC |
|
Truncates a number to an integer by discarding the fractional portion of the number. |
|
|
|
|
TYPE |
|
Returns a number that represents the type of data in the cell or field (1=blank, 2=logical, 3=number, 4=text). |
|
|
|
|
UPPER |
|
Converts lowercase characters in text to uppercase. |
|
|
|
|
VAR |
|
Calculates the variance of a population based on a sample. |
|
|
|
|
VLOOKUP (Vertical Lookup) |
|
Searches for a specific value in the left row of a range of cells. |
|
|
|
|
WEEKDAY |
|
Returns the day of the week (1=Sunday) represented by a date serial number. |
|
|
|
|
WEEKOFYEAR |
|
Returns the number of the week (1-52) represented by a date serial number. |
|
|
|
|
YEAR |
|
Returns the year represented by a date serial number. |
|
|
|