# Using math operations and formulas in SciNote tables

Tables that are created under the section Table in a protocol step or under *Results* in SciNote support basic math operations just as Excel spreadsheets do, but with some exceptions. The functions that can be used in SciNote tables are the following:

**SUM** adds together a supplied set of numbers and returns the sum of these values (e.g. =SUM(C1;D1));
**AVERAGE** returns the arithmetic mean of a list of supplied numbers;
**MEDIAN** returns the statistical median (the middle value) of a list of supplied numbers;
**MAX** returns the largest value from a supplied set of numeric values;
**MIN** returns the smallest value from a supplied set of numeric values;
**SLOPE** calculates the slope of the linear regression line through a supplied set of x- and y- values;
**IF** tests a supplied condition and returns one result if the condition evaluates to TRUE, and another result if the condition evaluates to FALSE;
**SQRT** calculates the positive square root of a supplied number;
**POWER** calculates a given number raised to a supplied power;
**LOG** calculates the logarithm of a given number, to a supplied base;
**LN** calculates the natural logarithm of a given number;
**LOG10** calculates the base 10 logarithm of a given number.

**PRODUCT** function can't be used in SciNote tables, but you can use ***** instead.

Furthermore, when copy-pasting the numbers from the Excel file to the SciNote table, you need to open the view *Show formulas* in an Excel file first (see the image below) and then copy the content and paste it into the SciNote table using CTRL + V keys.

Please note that formulas are based on the position of cells, so if you copy-paste Excel table cells from C37:C44 to SciNote table cells A1:A8 the formulas won't function because of different cell positions.

Tables that are created in the rich text fields do not support formulas, they do, however, have formatting options.

If you have any questions, please send us an email to **support@scinote.net**. For more information about the Premium plans, please **request a quote**.