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.