--- title: How to Use Math Operations and Formulas in SciNote Tables description: Tables that are created by inserting the 'Table' content block in a Task Protocol Step or under Results in SciNote support math operations just as Excel spreadsheets do, but with some exceptions. --- [Skip to content](https://knowledgebase.scinote.net/en/knowledge/how-to-use-math-operations-and-formulas-in-scinote-tables#main-content) English Show submenu for translations [Leave us a message](https://knowledgebase.scinote.net/en/knowledge/kb-tickets/new?hsLang=en) ![SciNote\_logo\_color\_2023.png\]](https://knowledgebase.scinote.net/hs-fs/hubfs/SciNote_logo_color_2023.png?height=40&name=SciNote_logo_color_2023.png) Open main navigation Close main navigation - English Show submenu for translations - [Leave us a message](https://knowledgebase.scinote.net/en/knowledge/kb-tickets/new) - Contact us Contact us How can we help you? - There are no suggestions because the search field is empty. 1. [Customer Support](https://knowledgebase.scinote.net/en/knowledge?hsLang=en) 2. [Getting Started](https://knowledgebase.scinote.net/en/knowledge/getting-started?hsLang=en) 3. [How to get most out of SciNote](https://knowledgebase.scinote.net/en/knowledge/getting-started?hsLang=en#how-to-get-most-out-of-scinote) # How to Use Math Operations and Formulas in SciNote Tables ## Tables that are created by inserting the 'Table' content block in a Task Protocol Step or under Results in SciNote support math operations just as Excel spreadsheets do, but with some exceptions. #### All the functions that can be used in SciNote tables can be found in the link below. Download and search the file to find the formulas you need: [Download the SciNote Table Formulas Here](https://knowledgebase.scinote.net/hubfs/Native_Tables_Formulas_Excel_Mapping.xlsx?hsLang=en) [![Table Formulas](https://knowledgebase.scinote.net/hs-fs/hubfs/Table%20Formulas.jpg?width=670&height=472&name=Table%20Formulas.jpg)](https://knowledgebase.scinote.net/hubfs/%5BCS%5D%20-%20Content/Native%20Tables%20Formulas.xlsx?hsLang=en) ### Example Formula/Operation in SciNote Table In order to use a formula within a SciNote table cell, double click into the cell, type the '=' sign, type the Formula Name, and then use the designated syntax to complete the formula. - e.g., '=DIVIDE(D2,D3)' like below [![Example Formula in SciNote Table](https://knowledgebase.scinote.net/hs-fs/hubfs/Example%20Formula%20in%20SciNote%20Table.png?width=670&height=299&name=Example%20Formula%20in%20SciNote%20Table.png)](https://knowledgebase.scinote.net/hubfs/Example%20Formula%20in%20SciNote%20Table.png?hsLang=en) If an error occurs, you can click the 'Refresh Formulas' button in the table to restore all existing formulas. [![restore button](https://knowledgebase.scinote.net/hs-fs/hubfs/restore%20button.png?width=628&height=385&name=restore%20button.png)](https://knowledgebase.scinote.net/hubfs/restore%20button.png?hsLang=en) --- If you have any additional questions, contact us at **[support@scinote.net](mailto:support@scinote.net).** For more information about the Premium plans, please **[request a quote.](https://www.scinote.net/get-a-quote-pricing/)**  - [Getting Started](https://knowledgebase.scinote.net/en/knowledge/getting-started?hsLang=en#main-content) - [First Steps](https://knowledgebase.scinote.net/en/knowledge/getting-started?hsLang=en#first-steps) - [How to get most out of SciNote](https://knowledgebase.scinote.net/en/knowledge/getting-started?hsLang=en#how-to-get-most-out-of-scinote) - [Using SciNote](https://knowledgebase.scinote.net/en/knowledge/using-scinote?hsLang=en#main-content) - [General](https://knowledgebase.scinote.net/en/knowledge/using-scinote?hsLang=en#general) - [Protocols](https://knowledgebase.scinote.net/en/knowledge/using-scinote?hsLang=en#protocols) - [Experiments](https://knowledgebase.scinote.net/en/knowledge/using-scinote?hsLang=en#experiments) - [Tasks and workflows](https://knowledgebase.scinote.net/en/knowledge/using-scinote?hsLang=en#tasks-and-workflows) - [Inventory](https://knowledgebase.scinote.net/en/knowledge/using-scinote?hsLang=en#inventory) - [App](https://knowledgebase.scinote.net/en/knowledge/using-scinote?hsLang=en#app) - [Frequently Asked Questions](https://knowledgebase.scinote.net/en/knowledge/frequently-asked-questions?hsLang=en#main-content) - [Troubleshooting](https://knowledgebase.scinote.net/en/knowledge/frequently-asked-questions?hsLang=en#troubleshooting) - [General](https://knowledgebase.scinote.net/en/knowledge/frequently-asked-questions?hsLang=en#general) - [Self-Guided Learning](https://knowledgebase.scinote.net/en/knowledge/self-guided-learning?hsLang=en#main-content) - [Courses](https://knowledgebase.scinote.net/en/knowledge/self-guided-learning?hsLang=en#courses) - [Video Tutorials](https://knowledgebase.scinote.net/en/knowledge/self-guided-learning?hsLang=en#video-tutorials) - [In-app Guides](https://knowledgebase.scinote.net/en/knowledge/self-guided-learning?hsLang=en#in-app-guides) - [Account Settings and Management](https://knowledgebase.scinote.net/en/knowledge/account-settings-and-management?hsLang=en#main-content) - [Account settings and preferences](https://knowledgebase.scinote.net/en/knowledge/account-settings-and-management?hsLang=en#account-settings-and-preferences) - [Organization and Workspace settings](https://knowledgebase.scinote.net/en/knowledge/account-settings-and-management?hsLang=en#organization-and-workspace-settings) - [Users and permissions](https://knowledgebase.scinote.net/en/knowledge/account-settings-and-management?hsLang=en#users-and-permissions) - [Referrals](https://knowledgebase.scinote.net/en/knowledge/account-settings-and-management?hsLang=en#referrals) - [Installations and Integrations](https://knowledgebase.scinote.net/en/knowledge/installations-and-integrations?hsLang=en#main-content) - [Hosting and local installation](https://knowledgebase.scinote.net/en/knowledge/installations-and-integrations?hsLang=en#hosting-and-local-installation) - [Integrations](https://knowledgebase.scinote.net/en/knowledge/installations-and-integrations?hsLang=en#integrations) - [Technical specifications and programming](https://knowledgebase.scinote.net/en/knowledge/installations-and-integrations?hsLang=en#technical-specifications-and-programming) - [Privacy and Data Security](https://knowledgebase.scinote.net/en/knowledge/privacy-and-data-security?hsLang=en#main-content) - [Account access](https://knowledgebase.scinote.net/en/knowledge/privacy-and-data-security?hsLang=en#account-access) - [Activity log and data traceability](https://knowledgebase.scinote.net/en/knowledge/privacy-and-data-security?hsLang=en#activity-log-and-data-traceability) - [Data security](https://knowledgebase.scinote.net/en/knowledge/privacy-and-data-security?hsLang=en#data-security) - [Billing and Pricing](https://knowledgebase.scinote.net/en/knowledge/billing-and-pricing?hsLang=en#main-content) - [Subscription and billing](https://knowledgebase.scinote.net/en/knowledge/billing-and-pricing?hsLang=en#subscription-and-billing) - [Default HubSpot Blog](https://scinote-3850750.hs-sites.com/blog) [![Chill listening crop-3](https://knowledgebase.scinote.net/hs-fs/hubfs/SciNote-Logo-2018-1024x203-1.png?width=151&height=30&name=SciNote-Logo-2018-1024x203-1.png "Chill listening crop-3")](https://www.scinote.net/) Customer Support Copyright © 2026, SCINOTE LLC