Alphabetical list of functions

    Click a function name to see more information about it.

      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.

Related topics

 


Table of contents | Index