Tables in SciNote support basic math operations just as Excel spreadsheets do, but with some exceptions. The functions that can be used in SciNote are the following:

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