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.
Please note that our table solution does not support cellclicking for formula input. Users are required to manually enter operations, providing a simplified approach without the complexities of Excel's extensive functionalities. As an alternative we suggest you use MS Office online integration as an alternative for some more complex operations.
The functions that can be used in SciNote tables are the following:
Function name 
Type and description 
Date and time: Returns the serial number of a particular date 

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

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

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

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

Logical: Returns TRUE if all of its arguments are TRUE 

Logical: Returns the logical value FALSE 

Logical: Specifies a logical test to perform 

Logical: Reverses the logic of its argument 

Logical: Returns TRUE if any argument is TRUE 

Logical: Returns the logical value TRUE 

Math and trigonometry: Returns the absolute value of a number 

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

Math and trigonometry: Returns the natural logarithm of a number 

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

Math and trigonometry: Returns the base10 logarithm of a number 

Math and trigonometry: Returns the value of pi 

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

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

Math and trigonometry: Returns a positive square root 

Math and trigonometry: Adds its arguments 

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

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

Math and trigonometry: Truncates a number to an integer 

Statistical: Returns the average of its arguments 

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

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

Statistical: Returns the correlation coefficient between two data sets 

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

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

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

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

Statistical: Returns the intercept of the linear regression line 

Statistical: Returns the maximum value in a list of arguments 

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

Statistical: Returns the median of the given numbers 

Statistical: Returns the minimum value in a list of arguments 

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

Statistical: Returns the slope of the linear regression line 

Statistical: Calculates standard deviation based on the entire population 

Statistical: Estimates standard deviation based on a sample 

Statistical: Returns the probability associated with a Student's ttest 

Text: Returns the character specified by the code number 

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

Text: Joins several text items into one text item 

Text: Checks to see if two text values are identical 
PRODUCT function can't be used in SciNote tables, but you can use * instead.
When copypasting the numbers from the Excel file to the SciNote table, you need to open the view Show formulas in an Excel file first. Then copy the content and paste it into the SciNote table using CTRL + V keys.
Formulas are based on the position of cells, so if you copypaste Excel table cells from C37:C44 to SciNote table cells A1:A8 the formulas won't function because of different cell positions.
If you have any additional questions, please, do not hesitate to contact us at support@scinote.net. For more information about the Premium plans, please request a quote.