When entering a formula in a cell, begin with\u00a0=.<\/p>\n\n\n\n
Example:\u00a0=1+2<\/p>\n\n\n\n To use the value of another cell, refer to it by its cell name.<\/p>\n\n\n\n Example:\u00a0=A1+B1<\/p>\n\n\n\n To specify multiple cells together, use\u00a0:.<\/p>\n\n\n\n Example:\u00a0=SUM(A1:A10)<\/p>\n\n\n\n You can use\u00a0+,\u00a0-,\u00a0*, and\u00a0\/.<\/p>\n\n\n\n Example:\u00a0=(A1+B1)*2<\/p>\n\n\n\n Formulas are evaluated according to standard calculation rules.<\/p>\n\n\n\n \u2022 *\u00a0and\u00a0\/\u00a0are evaluated first<\/p>\n\n\n\n \u2022 +\u00a0and\u00a0–\u00a0are evaluated after that<\/p>\n\n\n\n \u2022 You can use parentheses\u00a0()\u00a0to explicitly specify the order<\/p>\n\n\n\n \u2022 While editing a formula, you can tap another cell to insert a cell reference (for example,\u00a0A1).<\/p>\n\n\n\n \u2022 If there is a problem with the input,\u00a0Error\u00a0will be displayed.<\/p>\n\n\n\n <\/p>\n","protected":false},"excerpt":{"rendered":" This page explains the basic rules for entering formulas. Start formulas with = When entering a formula in a cell, begin with\u00a0=. Example:\u00a0=1+2 Use cell references To use the value of another cell, refer to it by its cell name. Example:\u00a0=A1+B1 Use range references To specify multiple cells together, use\u00a0:. Example:\u00a0=SUM(A1:A10) You can use basic […]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_locale":"en_US","_original_post":"https:\/\/tablenote.webdia.net\/?page_id=321","footnotes":""},"class_list":["post-466","page","type-page","status-publish","hentry","en-US"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/tablenote.webdia.net\/wp-json\/wp\/v2\/pages\/466","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tablenote.webdia.net\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/tablenote.webdia.net\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/tablenote.webdia.net\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/tablenote.webdia.net\/wp-json\/wp\/v2\/comments?post=466"}],"version-history":[{"count":0,"href":"https:\/\/tablenote.webdia.net\/wp-json\/wp\/v2\/pages\/466\/revisions"}],"wp:attachment":[{"href":"https:\/\/tablenote.webdia.net\/wp-json\/wp\/v2\/media?parent=466"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}![\"\"](\"https:\/\/tablenote.webdia.net\/wp-content\/uploads\/2026\/04\/page-321-1-471x1024.png\"){kind=spacer}
<\/figure>\n\n\n\n
\n\n\n\nUse cell references<\/strong><\/h2>\n\n\n\n
![\"\"](\"https:\/\/tablenote.webdia.net\/wp-content\/uploads\/2026\/04\/page-321-2-471x1024.png\"){kind=spacer}
<\/figure>\n\n\n\n
\n\n\n\nUse range references<\/strong><\/strong><\/h2>\n\n\n\n
![\"\"](\"https:\/\/tablenote.webdia.net\/wp-content\/uploads\/2026\/04\/page-321-3-471x1024.png\"){kind=spacer}
<\/figure>\n\n\n\n
\n\n\n\nYou can use basic arithmetic operations<\/strong><\/strong><\/h2>\n\n\n\n
![\"\"](\"https:\/\/tablenote.webdia.net\/wp-content\/uploads\/2026\/04\/page-321-4-471x1024.png\"){kind=spacer}
<\/figure>\n\n\n\n
\n\n\n\nOrder of operations<\/strong><\/strong><\/h2>\n\n\n\n
\n\n\n\n\u88dc\u8db3<\/strong><\/h2>\n\n\n\n