{"id":12151,"date":"2012-07-16T16:30:29","date_gmt":"2012-07-16T16:30:29","guid":{"rendered":"http:\/\/www.learnexcelmacro.com\/?p=2115"},"modified":"2017-07-17T09:07:23","modified_gmt":"2017-07-17T09:07:23","slug":"excel-formula-basics","status":"publish","type":"post","link":"https:\/\/vmlogger.com\/excel\/2012\/07\/excel-formula-basics\/","title":{"rendered":"What is Excel Formula ? How to use Excel Formula?"},"content":{"rendered":"

This Article is written for the people who does not know about Excel formula. This article answers following questions about Excel Formulas:
\n 
\n
\n1. What is Excel Formula?
\n2. How to Use Excel Formula – a step by step tutorial.
\n3. How an Excel Formula works in Excel?
\n4. How to refer a Cell in Excel Formula?
\n5. What is Cell Address?
\n<\/strong>
\n<\/p>\n

What is Excel Formula ?<\/h1>\n

Excel Formula is one of the best feature in Microsoft Excel, which makes Excel a very very rich application. There are so many useful built-in formulas available in Excel, which makes our work easier in Excel. For all the automated work, Excel Macro is not required. There are so many automated things can be done by using simple formulas in Excel. Formulas are simple text (With a Syntax) which is entered in to the Excel Worksheet Cells. So how computer will recognize whether it is a formula or simple text? Answer is simple.. every formula in Excel starts with Equal Sign (=) <\/strong>. It means whenever the first letter of a cell is Equal Sign then Excel recognize it as a formula. All the text after Equal Sign is considered as Formula.
\n <\/p>\n

How to Use Excel Formula – Step by Step<\/h1>\n\n\n
\n
\n1. Select the Cell where you want to place your formula. 2. Type the Equal (=) sign.<\/p>\n

Note: <\/strong> After typing = sign if you Click on Any other Cell then the Address of that Cell will be automatically placed there. So be careful while writing a formula in Excel. While writing formula DO NOT select any other cell, unless you want to refer that Cell in to your formula. Therefore you can refer a cell in to your formula in two ways:<\/em><\/p>\n

i) By typing the Address of that Cell (like A1, B8 etc)<\/em><\/p>\n

ii) By Selecting that Cell while writing your formula.<\/em><\/p>\n

3. Type the address of the cell to include in the formula or Select that Cell.<\/p>\n

4. Type the Formula as per the Syntax of that Formula<\/p>\n

5. Press Enter or Press Tab Key. (Again after writing the Complete formula, do not click somewhere else, instead you need to press Enter or Tab key Only)
\n6. And now you are done.
\n<\/font><\/p>\n<\/td>\n<\/tr>\n<\/table>\n

\nLet’s take an example of Simple Formula in Excel.<\/strong>
\n<\/p>\n

In Cell A1, I have value as 10 and in Cell B1, I have value 5. I want sum of these two Cell values in Cell C1.<\/p>\n

1. Click on Cell C1
\n2. Type Equal to Sign (=)
\n3. Now Take your mouse at Cell A1. Automatically the Cell Address A1 will be typed in Cell C1.
\n4. Now Type Plus Sign ( + )
\n5. Now Click on the Cell B1. (Same as previously this time B1 Cell Address will be typed)
\n6. Now It will look as same as shown in below:<\/p>\n

\n 
\n\"Excel\n<\/div>\n

 
\n7. Now press Enter
\n8. Value of Cell A1 (i.e. 10) and Value of Cell B1 (i.e. 5) will be added and the Result will be shown in Cell C1 (Where formula is written).
\n <\/p>\n

\n\"Excel<\/div>\n

 
\n<\/p>\n

Note:<\/strong> In the above Example, you can see that the Value of Cell is referred by the Address of that Cell. It means in Excel Formula if you want to Refer the Value of Cell then you can refer it by passing the Address of that Cell.
\nAddress of Cell is formed by Column Name and Row Number. It means if you want a Cell which is in Column J and Row 3 then the Address of the Cell will be J3<\/strong>
\n<\/p>\n\n\n
\n<\/p>\n

\nWant to Know Syntax and How to use most of the Important Formulas? Then Read Excel Formulas Tutorial Page.<\/a>
\n<\/h3>\n

\n<\/td>\n<\/tr>\n<\/table>\n<\/span>","protected":false},"excerpt":{"rendered":"

This Article is written for the people who does not know about Excel formula. This article answers following questions about Excel Formulas:   1. What is Excel Formula? 2. How to Use Excel Formula – a step by step tutorial. 3. How an Excel Formula works in Excel? 4. How to refer a Cell in […]<\/p>\n","protected":false},"author":45,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[1672],"tags":[],"class_list":["post-12151","post","type-post","status-publish","format-standard","hentry","category-excel-formula"],"yoast_head":"\nStep by Step Tutorial - How to use Excel Formula? What is Excel Formula?<\/title>\n<meta name=\"description\" content=\"Basics of Excel Formula. What is Excel Formula? How to Use Excel Formula - a step by step tutorial. How Excel Formula works in Excel? All about Excel Formulas\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/vmlogger.com\/excel\/2012\/07\/excel-formula-basics\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"What is Excel Formula ? How to use Excel Formula?\" \/>\n<meta property=\"og:description\" content=\"Basics of Excel Formula. What is Excel Formula? How to Use Excel Formula - a step by step tutorial. How Excel Formula works in Excel? All about Excel Formulas\" \/>\n<meta property=\"og:url\" content=\"https:\/\/vmlogger.com\/excel\/2012\/07\/excel-formula-basics\/\" \/>\n<meta property=\"og:site_name\" content=\"Let's excel in Excel\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/vmlogger\" \/>\n<meta property=\"article:author\" content=\"http:\/\/www.facebook.com\/vmlogger\" \/>\n<meta property=\"article:published_time\" content=\"2012-07-16T16:30:29+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2017-07-17T09:07:23+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/learnexcelmacro.com\/wp\/wp-content\/uploads\/sites\/11\/2011\/11\/Excel-Formula-1.png\" \/>\n<meta name=\"author\" content=\"Vishwamitra Mishra\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@https:\/\/www.twitter.com\/learnexcelmacro\" \/>\n<meta name=\"twitter:site\" content=\"@learnexcelmacro\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Vishwamitra Mishra\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2012\/07\/excel-formula-basics\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2012\/07\/excel-formula-basics\/\"},\"author\":{\"name\":\"Vishwamitra Mishra\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"headline\":\"What is Excel Formula ? How to use Excel Formula?\",\"datePublished\":\"2012-07-16T16:30:29+00:00\",\"dateModified\":\"2017-07-17T09:07:23+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2012\/07\/excel-formula-basics\/\"},\"wordCount\":594,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"image\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2012\/07\/excel-formula-basics\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2011\/11\/Excel-Formula-1.png\",\"articleSection\":[\"Excel Formula\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/vmlogger.com\/excel\/2012\/07\/excel-formula-basics\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2012\/07\/excel-formula-basics\/\",\"url\":\"https:\/\/vmlogger.com\/excel\/2012\/07\/excel-formula-basics\/\",\"name\":\"Step by Step Tutorial - How to use Excel Formula? What is Excel Formula?\",\"isPartOf\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2012\/07\/excel-formula-basics\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2012\/07\/excel-formula-basics\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2011\/11\/Excel-Formula-1.png\",\"datePublished\":\"2012-07-16T16:30:29+00:00\",\"dateModified\":\"2017-07-17T09:07:23+00:00\",\"description\":\"Basics of Excel Formula. What is Excel Formula? How to Use Excel Formula - a step by step tutorial. How Excel Formula works in Excel? All about Excel Formulas\",\"breadcrumb\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2012\/07\/excel-formula-basics\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/vmlogger.com\/excel\/2012\/07\/excel-formula-basics\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2012\/07\/excel-formula-basics\/#primaryimage\",\"url\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2011\/11\/Excel-Formula-1.png\",\"contentUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2011\/11\/Excel-Formula-1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2012\/07\/excel-formula-basics\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/vmlogger.com\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel Formula\",\"item\":\"https:\/\/vmlogger.com\/excel\/excel-formula\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"What is Excel Formula ? How to use Excel Formula?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#website\",\"url\":\"https:\/\/vmlogger.com\/excel\/\",\"name\":\"Let's excel in Excel\",\"description\":\"Let's share knowledge\",\"publisher\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/vmlogger.com\/excel\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\",\"name\":\"Vishwamitra Mishra\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png\",\"contentUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png\",\"width\":528,\"height\":560,\"caption\":\"Vishwamitra Mishra\"},\"logo\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/\"},\"description\":\"My name is Vishwamitra Mishra. Friends Call me Vishwa. I hold a Bachelor\u2019s Degree in Computer Science from D.A.V.V. Indore & currently working as a Technical Lead having over 7 years of experience.\",\"sameAs\":[\"http:\/\/www.learnexcelmacro.com\",\"http:\/\/www.facebook.com\/vmlogger\",\"https:\/\/x.com\/https:\/\/www.twitter.com\/learnexcelmacro\",\"https:\/\/www.youtube.com\/c\/VMLogger\"],\"url\":\"https:\/\/vmlogger.com\/excel\/author\/vishwamitra\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Step by Step Tutorial - How to use Excel Formula? What is Excel Formula?","description":"Basics of Excel Formula. What is Excel Formula? How to Use Excel Formula - a step by step tutorial. How Excel Formula works in Excel? All about Excel Formulas","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/vmlogger.com\/excel\/2012\/07\/excel-formula-basics\/","og_locale":"en_US","og_type":"article","og_title":"What is Excel Formula ? How to use Excel Formula?","og_description":"Basics of Excel Formula. What is Excel Formula? How to Use Excel Formula - a step by step tutorial. How Excel Formula works in Excel? All about Excel Formulas","og_url":"https:\/\/vmlogger.com\/excel\/2012\/07\/excel-formula-basics\/","og_site_name":"Let's excel in Excel","article_publisher":"http:\/\/www.facebook.com\/vmlogger","article_author":"http:\/\/www.facebook.com\/vmlogger","article_published_time":"2012-07-16T16:30:29+00:00","article_modified_time":"2017-07-17T09:07:23+00:00","og_image":[{"url":"http:\/\/learnexcelmacro.com\/wp\/wp-content\/uploads\/sites\/11\/2011\/11\/Excel-Formula-1.png"}],"author":"Vishwamitra Mishra","twitter_card":"summary_large_image","twitter_creator":"@https:\/\/www.twitter.com\/learnexcelmacro","twitter_site":"@learnexcelmacro","twitter_misc":{"Written by":"Vishwamitra Mishra","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/vmlogger.com\/excel\/2012\/07\/excel-formula-basics\/#article","isPartOf":{"@id":"https:\/\/vmlogger.com\/excel\/2012\/07\/excel-formula-basics\/"},"author":{"name":"Vishwamitra Mishra","@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"headline":"What is Excel Formula ? How to use Excel Formula?","datePublished":"2012-07-16T16:30:29+00:00","dateModified":"2017-07-17T09:07:23+00:00","mainEntityOfPage":{"@id":"https:\/\/vmlogger.com\/excel\/2012\/07\/excel-formula-basics\/"},"wordCount":594,"commentCount":0,"publisher":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"image":{"@id":"https:\/\/vmlogger.com\/excel\/2012\/07\/excel-formula-basics\/#primaryimage"},"thumbnailUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2011\/11\/Excel-Formula-1.png","articleSection":["Excel Formula"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/vmlogger.com\/excel\/2012\/07\/excel-formula-basics\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/vmlogger.com\/excel\/2012\/07\/excel-formula-basics\/","url":"https:\/\/vmlogger.com\/excel\/2012\/07\/excel-formula-basics\/","name":"Step by Step Tutorial - How to use Excel Formula? What is Excel Formula?","isPartOf":{"@id":"https:\/\/vmlogger.com\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/vmlogger.com\/excel\/2012\/07\/excel-formula-basics\/#primaryimage"},"image":{"@id":"https:\/\/vmlogger.com\/excel\/2012\/07\/excel-formula-basics\/#primaryimage"},"thumbnailUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2011\/11\/Excel-Formula-1.png","datePublished":"2012-07-16T16:30:29+00:00","dateModified":"2017-07-17T09:07:23+00:00","description":"Basics of Excel Formula. What is Excel Formula? How to Use Excel Formula - a step by step tutorial. How Excel Formula works in Excel? All about Excel Formulas","breadcrumb":{"@id":"https:\/\/vmlogger.com\/excel\/2012\/07\/excel-formula-basics\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/vmlogger.com\/excel\/2012\/07\/excel-formula-basics\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/vmlogger.com\/excel\/2012\/07\/excel-formula-basics\/#primaryimage","url":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2011\/11\/Excel-Formula-1.png","contentUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2011\/11\/Excel-Formula-1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/vmlogger.com\/excel\/2012\/07\/excel-formula-basics\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/vmlogger.com\/excel\/"},{"@type":"ListItem","position":2,"name":"Excel Formula","item":"https:\/\/vmlogger.com\/excel\/excel-formula\/"},{"@type":"ListItem","position":3,"name":"What is Excel Formula ? How to use Excel Formula?"}]},{"@type":"WebSite","@id":"https:\/\/vmlogger.com\/excel\/#website","url":"https:\/\/vmlogger.com\/excel\/","name":"Let's excel in Excel","description":"Let's share knowledge","publisher":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/vmlogger.com\/excel\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5","name":"Vishwamitra Mishra","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/","url":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png","contentUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png","width":528,"height":560,"caption":"Vishwamitra Mishra"},"logo":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/"},"description":"My name is Vishwamitra Mishra. Friends Call me Vishwa. I hold a Bachelor\u2019s Degree in Computer Science from D.A.V.V. Indore & currently working as a Technical Lead having over 7 years of experience.","sameAs":["http:\/\/www.learnexcelmacro.com","http:\/\/www.facebook.com\/vmlogger","https:\/\/x.com\/https:\/\/www.twitter.com\/learnexcelmacro","https:\/\/www.youtube.com\/c\/VMLogger"],"url":"https:\/\/vmlogger.com\/excel\/author\/vishwamitra\/"}]}},"_links":{"self":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts\/12151"}],"collection":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/users\/45"}],"replies":[{"embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/comments?post=12151"}],"version-history":[{"count":0,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts\/12151\/revisions"}],"wp:attachment":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/media?parent=12151"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/categories?post=12151"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/tags?post=12151"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}