How to Use Math Operations and Formulas in SciNote Tables

DATE function

Date and time:    Returns the serial number of a particular date

DATEVALUE function

Date and time:    Converts a date in the form of text to a serial number

DAY function

Date and time:    Converts a serial number to a day of the month

DAYS function

Date and time:    Returns the number of days between two dates

EDATE function

Date and time:    Returns the serial number of the date that is the indicated number of months before or after the start date

AND function

Logical:    Returns TRUE if all of its arguments are TRUE

FALSE function

Logical:    Returns the logical value FALSE

IF function

Logical:    Specifies a logical test to perform

NOT function

Logical:    Reverses the logic of its argument

OR function

Logical:    Returns TRUE if any argument is TRUE

TRUE function

Logical:    Returns the logical value TRUE

ABS function

Math and trigonometry:    Returns the absolute value of a number

INT function

Math and trigonometry:    Rounds a number down to the nearest integer

LN function

Math and trigonometry:    Returns the natural logarithm of a number

LOG function

Math and trigonometry:    Returns the logarithm of a number to a specified base

LOG10 function

Math and trigonometry:    Returns the base-10 logarithm of a number

PI function

Math and trigonometry:    Returns the value of pi

POWER function

Math and trigonometry:    Returns the result of a number raised to a power

ROUND function

Math and trigonometry:    Rounds a number to a specified number of digits

SQRT function

Math and trigonometry:    Returns a positive square root

SUM function

Math and trigonometry:    Adds its arguments

SUMIF function

Math and trigonometry:    Adds the cells specified by a given criteria

SUMIFS function

Math and trigonometry:    Adds the cells in a range that meet multiple criteria

TRUNC function

Math and trigonometry:    Truncates a number to an integer

AVERAGE function

Statistical:    Returns the average of its arguments

AVERAGEA function

Statistical:    Returns the average of its arguments, including numbers, text, and logical values

AVERAGEIF function

Statistical:    Returns the average (arithmetic mean) of all the cells in a range that meet a given criteria

CORREL function

Statistical:    Returns the correlation coefficient between two data sets

COUNT function

Statistical:    Counts how many numbers are in the list of arguments

COUNTA function

Statistical:    Counts how many values are in the list of arguments

COUNTIF function

Statistical:    Counts the number of cells within a range that meet the given criteria

COUNTIFS function

Statistical:    Counts the number of cells within a range that meet multiple criteria

INTERCEPT function

Statistical:    Returns the intercept of the linear regression line

MAX function

Statistical:    Returns the maximum value in a list of arguments

MAXA function

Statistical:    Returns the maximum value in a list of arguments, including numbers, text, and logical values

MEDIAN function

Statistical:    Returns the median of the given numbers

MIN function

Statistical:    Returns the minimum value in a list of arguments

MINA function

Statistical:    Returns the smallest value in a list of arguments, including numbers, text, and logical values

SLOPE function

Statistical:    Returns the slope of the linear regression line

STDEV.P function

Statistical:    Calculates standard deviation based on the entire population

STDEV.S function

Statistical:    Estimates standard deviation based on a sample

T.TEST function

Statistical:    Returns the probability associated with a Student's t-test

CHAR function

Text:    Returns the character specified by the code number

CODE function

Text:    Returns a numeric code for the first character in a text string

CONCATENATE function

Text:    Joins several text items into one text item

EXACT function

Text:    Checks to see if two text values are identical