{"id":92504,"date":"2021-04-29T13:57:39","date_gmt":"2021-04-29T08:27:39","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=92504"},"modified":"2021-04-29T14:33:03","modified_gmt":"2021-04-29T09:03:03","slug":"formulas-and-calculations-in-ms-excel","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/formulas-and-calculations-in-ms-excel\/","title":{"rendered":"Formulas and Calculations in MS-Excel"},"content":{"rendered":"<p>MS-Excel is one of the software tools developed by Microsoft for easy computation, visual insights of the data using the features provided by the MS-Excel. In this tutorial of \u201cWhat are Formulas and Calculations in MS-Excel?\u201d, we\u2019ll learn how to do basic calculations in MS Excel and what are the different ways to do a computation.<\/p>\n<p>Performing calculations in MS-excel is quick and easy. The steps involved to do a calculation are very simple and there is nothing much to remember like you have to do in other coding languages.<\/p>\n<p>Let us start with knowing what is a calculation?<\/p>\n<p>In simple words, we could say calculation is a computation that starts with a \u2018=\u2019 symbol.<\/p>\n<h3><strong>Basic operations in MS-Excel are:<\/strong><\/h3>\n<ul>\n<li>Addition<\/li>\n<li>Subtraction<\/li>\n<li>Multiplication<\/li>\n<li>Division<\/li>\n<li>Percent<\/li>\n<li>Power<\/li>\n<li>Square Root<\/li>\n<\/ul>\n<p>A quick understanding of the basic operations in MS-Excel.<\/p>\n<table>\n<tbody>\n<tr>\n<td><b>Operation<\/b><\/td>\n<td><b>Operator<\/b><\/td>\n<td><b>Formula<\/b><\/td>\n<td><b>Description<\/b><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">Addition<\/span><\/td>\n<td><span style=\"font-weight: 400;\">+<\/span><\/td>\n<td><span style=\"font-weight: 400;\">=A1+A2<\/span><\/p>\n<p><span style=\"font-weight: 400;\">=sum(start cell:end cell)<\/span><\/td>\n<td><span style=\"font-weight: 400;\">Summing of two values in the cells A1 and A2.<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">Subtraction<\/span><\/td>\n<td><span style=\"font-weight: 400;\">&#8211;<\/span><\/td>\n<td><span style=\"font-weight: 400;\">=A1-A2<\/span><\/td>\n<td><span style=\"font-weight: 400;\">Subtraction of the value in the cell A2 from A1.<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">Multiplication<\/span><\/td>\n<td><span style=\"font-weight: 400;\">*<\/span><\/td>\n<td><span style=\"font-weight: 400;\">=A1*A2<\/span><\/td>\n<td><span style=\"font-weight: 400;\">Product of two values in the cells A1 and A2.<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">Division<\/span><\/td>\n<td><span style=\"font-weight: 400;\">\/<\/span><\/td>\n<td><span style=\"font-weight: 400;\">=A1\/A2<\/span><\/td>\n<td><span style=\"font-weight: 400;\">Dividing the value of cell A1 by the value in cell A2.<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">Percent\u00a0<\/span><\/td>\n<td><span style=\"font-weight: 400;\">%<\/span><\/td>\n<td><span style=\"font-weight: 400;\">=A1*A2%<\/span><\/td>\n<td><span style=\"font-weight: 400;\">To find A2% of the number in the cell A1.<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">Power<\/span><\/td>\n<td><span style=\"font-weight: 400;\">^<\/span><\/td>\n<td><span style=\"font-weight: 400;\">=A1^A2<\/span><\/td>\n<td><span style=\"font-weight: 400;\">Raising of the value in A1 by the power of A2.<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">Square Root<\/span><\/td>\n<td><span style=\"font-weight: 400;\">SQRT()<\/span><\/td>\n<td><span style=\"font-weight: 400;\">=sqrt(cell)<\/span><\/td>\n<td><span style=\"font-weight: 400;\">To find the square root of that particular cell.<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h3>1. Addition in MS Excel<strong><br \/>\n<\/strong><\/h3>\n<p><span style=\"font-weight: 400;\">Now, let\u2019s look at the ways in adding two or more values in a spreadsheet.<\/span><\/p>\n<p><strong>Steps to follow while summing up the values in the cells:<\/strong><\/p>\n<p>Step-1: You can just write the formula in the desired cell.<br \/>\nStep-2: Press <strong>ENTER<\/strong>.<\/p>\n<p><strong>For Example,<\/strong>\u00a0You wanted to add the values of A2&#8230;A6 cell and see the result in D2 cell.<br \/>\nHence, write <strong>=A2+A3+A4+A5+A6<\/strong> in <strong>D2<\/strong>.<br \/>\nAfter writing it, once you press <strong>ENTER, <\/strong>the result appears as below.<\/p>\n<p>The above method consumes much of the time if we have more data. To make it simpler and quicker, we can follow the SUM function method to calculate the sum in the spreadsheet.<\/p>\n<p>To do so, follow the below steps:<\/p>\n<p>Step &#8211; 1: Place the cursor on the desired cell.<br \/>\nStep &#8211; 2: Write the formula using the function \u201c=sum(start cell:end cell)\u201d.<\/p>\n<p><strong>Tip<\/strong>: When you don\u2019t have the idea from where it has to start and end, then, just click and drag on the data to which the computation should apply.<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/sum-function.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-92689\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/sum-function.png\" alt=\"sum function in MS Excel\" width=\"444\" height=\"249\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/sum-function.png 444w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/sum-function-300x168.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/sum-function-150x84.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/sum-function-320x179.png 320w\" sizes=\"auto, (max-width: 444px) 100vw, 444px\" \/><\/a><\/p>\n<p><strong>Note<\/strong>: Here the start cell mentions the first cell value of the sum computation. The end cell mentions the last cell value involved in the summation.<\/p>\n<p>From the sample, we can see that C3 is the desired cell. It contains the sum from A2 to A6. Hence, we can say that the start cell here is A2 and the end cell is A6.<\/p>\n<p>The above method is one of the most common methods to add multiple cells in a spreadsheet. Adding two or more cells is one of the basic operations performed in MS-Excel.<\/p>\n<h3>2. Subtraction in MS Excel<\/h3>\n<p>Next, let\u2019s have a look at how to find the difference between the two numbers.<\/p>\n<p>Another interesting fact in MS-Excel is that the operations are all similar. It does not have many changes in the steps. All that matters is that you have to provide the appropriate symbol for the calculation you are computing. Finally, you\u2019ll get the desired result.<\/p>\n<p>Now, let\u2019s find the difference between two cells in a spreadsheet. To find the difference, follow the below steps:<\/p>\n<p>Step-1: Write the formula in the desired cell.<br \/>\nStep-2: Press <strong>ENTER<\/strong>.<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/Difference.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-91982\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/Difference.png\" alt=\"Subtraction in MS Excel\" width=\"440\" height=\"294\" \/><\/a><\/p>\n<p>From the above sample, we can see that the difference between A6 and A5 in B8 using the formula\u201c=A6-A5\u201d.<\/p>\n<h3>3. Multiplication &amp; Division in MS Excel<\/h3>\n<p>Further, we\u2019ll look into the calculation of multiplication and division in the spreadsheet. To do so, follow the steps provided below:<\/p>\n<p>Step-1: Write the formula in the desired cell.<br \/>\nStep-2: Press <strong>ENTER<\/strong>.<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/multiplication.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-92691\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/multiplication.png\" alt=\"multiplication in MS Excel\" width=\"443\" height=\"297\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/multiplication.png 443w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/multiplication-300x201.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/multiplication-150x101.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/multiplication-320x215.png 320w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/multiplication-272x182.png 272w\" sizes=\"auto, (max-width: 443px) 100vw, 443px\" \/><\/a><\/p>\n<p>From the above sample, we can see that B8 contains the product value of A5 and A6 using the formula \u201c=A6*A5\u201d.<\/p>\n<p>You have to follow the same steps to do division also.<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/Division.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-91984\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/Division.png\" alt=\"Division in MS Excel\" width=\"441\" height=\"295\" \/><\/a><\/p>\n<p>From the above sample, we can see that B8 contains the value of A6 divided by A5.<\/p>\n<h3>4. Average in MS Excel<\/h3>\n<p>Now, let&#8217;s have a look at how to calculate the average of the cells specified. To calculate the average, follow the below steps.<\/p>\n<p>Step &#8211; 1: Choose the desired cell where you want to calculate the average.<br \/>\nStep &#8211; 2: Write the formula \u2018=average(start cell : end cell).<\/p>\n<p><strong>Note<\/strong>: If you don\u2019t know the start cell and the end cell, then just drag the cells by keeping the cursor inside the parentheses().<\/p>\n<p>Step &#8211; 3: Press ENTER.<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/average.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-92702\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/average.png\" alt=\"average in MS Excel\" width=\"465\" height=\"242\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/average.png 465w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/average-300x156.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/average-150x78.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/average-320x167.png 320w\" sizes=\"auto, (max-width: 465px) 100vw, 465px\" \/><\/a><\/p>\n<p>In the above sample, the C5 cell holds the average of A2&#8230;A6.<\/p>\n<h3>5. Percent in MS Excel<\/h3>\n<p>Next, we will see how to calculate the percent values in MS-Excel. To calculate the percent values, follow the below steps:<\/p>\n<p>Step -1: Choose the cell in which the percent value should appear.<br \/>\nStep-2: Write the formula =cell number * x%<\/p>\n<p><strong>Note<\/strong>: Here, x is the percentage value. The x value can be directly entered or it can also be a cell number.<\/p>\n<p>Step &#8211; 3: Press ENTER.<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/percent.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-92703\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/percent.png\" alt=\"Percent in MS Excel\" width=\"442\" height=\"271\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/percent.png 442w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/percent-300x184.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/percent-150x92.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/percent-320x196.png 320w\" sizes=\"auto, (max-width: 442px) 100vw, 442px\" \/><\/a><\/p>\n<p>From the sample, we can see that B7 holds the 10% percent value of A6. The percent value is 10 here and that value is also taken as a cell itself. <strong>It is in cell A5<\/strong>.<\/p>\n<h3>6. Power in MS Excel<\/h3>\n<p>Next, let\u2019s look at how to find the power of a number in MS-Excel. The same steps apply here also. Only the symbol keeps changing.<\/p>\n<p>To find the power of a number, we\u2019ll use the notation \u201c^\u201d between the numbers.<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/Power.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-92711\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/Power.png\" alt=\"Power in MS Excel\" width=\"443\" height=\"293\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/Power.png 443w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/Power-300x198.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/Power-150x99.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/Power-320x212.png 320w\" sizes=\"auto, (max-width: 443px) 100vw, 443px\" \/><\/a><\/p>\n<p>From the sample, we can see that B8 contains the power of the desired cell.<\/p>\n<p>The base in this sample is A6 and the power is A2. Hence, we write it as A6^A2 in B8.<\/p>\n<h3>7. Nth Root in MS Excel<\/h3>\n<p>We can also find the nth root of a cell using the formula of= ^(1\/n). Here n = root to find.<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/n-th-root.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-91988\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/n-th-root.png\" alt=\"Nth Root in MS Excel\" width=\"462\" height=\"322\" \/><\/a><\/p>\n<p><span style=\"font-weight: 400;\">In the above sample, we have found the 1\/nth root of A6 in the cell B8. Here n=10 and even that value is taken from cell A5.\u00a0<\/span><\/p>\n<h3>8. Square Root in MS Excel<\/h3>\n<p>Now, Let\u2019s calculate the square root of a number. To calculate the square root, we\u2019ll be using the function SQRT().<\/p>\n<p>Step -1: Click on the cell in which square root of a number should appear.<br \/>\nStep -2: Write the function i.e., =sqrt(cell) or sqrt(number).<br \/>\nStep-3: Press ENTER.<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/sqrt.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-92714\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/sqrt.png\" alt=\"Square root in MS Excel\" width=\"437\" height=\"241\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/sqrt.png 437w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/sqrt-300x165.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/sqrt-150x83.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/sqrt-320x176.png 320w\" sizes=\"auto, (max-width: 437px) 100vw, 437px\" \/><\/a><\/p>\n<p>In the sample, we can see that the C5 cell holds the square root of the cell A6. Let us also have a look at how to perform the Trim function:<\/p>\n<p><strong>TRIM<\/strong>:<\/p>\n<p>Trim is a function that helps in removing the extra spaces in a cell. It works only on a single cell at a time. To apply the function \u2018Trim()\u2019, follow the steps as below:<\/p>\n<p>1: Choose a cell where the trimmed data should appear.<br \/>\n2: Write the function as \u2018=TRIM(cell number)\u2019<br \/>\n3: Press Enter.<\/p>\n<p>Let&#8217;s look at a sample of how it works:<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/trim.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-92724\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/trim.png\" alt=\"Trim in MS Excel\" width=\"487\" height=\"159\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/trim.png 487w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/trim-300x98.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/trim-150x49.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/trim-320x104.png 320w\" sizes=\"auto, (max-width: 487px) 100vw, 487px\" \/><\/a><\/p>\n<p><span style=\"font-weight: 400;\">From the sample, the elimination of extra space in the cell A2 has taken place and the result is observed in cell B2.<\/span><\/p>\n<h3>9. Concatenation in MS Excel<\/h3>\n<p>Concatenation is the merging of two or more cell values in a single cell. Usually, \u201c&amp;\u201d is known as the concatenation operator. To do this, we can use the formula \u2018=cell1 &amp; cell2 &amp; cell3 &amp; \u2026\u2026.&amp;cell n\u2019<\/p>\n<p><strong>Note<\/strong>: If we want space between the cells then re-write the formula as \u2018=cell1&amp;\u201d \u201c&amp;cell2&amp;\u201d &#8230;\u201c&amp;cell n\u2019. The space character(\u201c \u201d) represents the space between the concat words. To apply concatenation in your MS-Excel, follow the below steps:<\/p>\n<p>1: Choose the cell where the concatenation should take place.<br \/>\n2: Write the formula<br \/>\n3: Press ENTER.<\/p>\n<p>Let\u2019s look at a sample of how concatenation works.<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/concatenation.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-92725\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/concatenation.png\" alt=\"concatenation in MS Excel\" width=\"730\" height=\"295\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/concatenation.png 730w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/concatenation-300x121.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/concatenation-150x61.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/concatenation-720x291.png 720w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/concatenation-520x210.png 520w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/concatenation-320x129.png 320w\" sizes=\"auto, (max-width: 730px) 100vw, 730px\" \/><\/a><\/p>\n<p><span style=\"font-weight: 400;\">Using the formula, we have concatenated the words in B1 and B2. If we want to add space in between the words, then add an ampersand with a blank space in between the quotation(&amp; \u201c \u201c&amp;).<\/span><\/p>\n<p><span style=\"font-weight: 400;\">There is also another way to concatenate the values in the cell and that is by using CONCATENATE function.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">To concatenate using the function, follow the below steps:<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Step &#8211; 1: Choose the cell where the concatenation should take place.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Step &#8211; 2: Write the function formula \u2018=concatenate(cell value, cell value,..cell value).<\/span><\/p>\n<p><span style=\"font-weight: 400;\"><strong>Note<\/strong>: If you want to add space between the words then write the function as \u2018=concatenate(cell value, \u201c \u201d, cell value, \u201c \u201d ,&#8230;cell value)\u2019.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Step &#8211; 3: Press ENTER.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Have a look at the image below for a clear understanding:<\/span><\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/concatenate-using-function.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-92726\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/concatenate-using-function.png\" alt=\"concatenate using function in MS Excel\" width=\"846\" height=\"282\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/concatenate-using-function.png 846w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/concatenate-using-function-300x100.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/concatenate-using-function-150x50.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/concatenate-using-function-768x256.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/concatenate-using-function-720x240.png 720w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/concatenate-using-function-520x173.png 520w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/concatenate-using-function-320x107.png 320w\" sizes=\"auto, (max-width: 846px) 100vw, 846px\" \/><\/a><\/p>\n<h3>10. Comparisons in MS Excel<\/h3>\n<p><span style=\"font-weight: 400;\">Using logical operators, we can perform the comparisons. If the condition satisfies, then the result appears either as true or false.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">The logical operators are:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><strong>= (Equal to)<\/strong><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">Checks whether the data on the right and the left-hand side are equal.<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><strong>&lt; (Lesser than)<\/strong><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">Checks whether the data on the left-hand side is lesser than the right-hand side data value.<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><strong>&gt; (Greater Than)<\/strong><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">Checks whether the data on the left-hand side is greater than the right-hand side data value.<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><strong>&lt;= (Lesser than or equal to)<\/strong><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">Checks whether the data on the left-hand side is lesser than or equal to the right-hand side data.<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><strong>&gt;= (Greater than or Equal to)<\/strong><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">Checks whether the data on the left-hand side is greater than or equal to right-hand side data.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Let&#8217;s see how this works on excel with a sample.<\/span><\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/Comaprison-Table.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-92730\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/Comaprison-Table.png\" alt=\"Comparison in MS Excel\" width=\"880\" height=\"303\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/Comaprison-Table.png 880w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/Comaprison-Table-300x103.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/Comaprison-Table-150x52.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/Comaprison-Table-768x264.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/Comaprison-Table-720x248.png 720w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/Comaprison-Table-520x179.png 520w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/Comaprison-Table-320x110.png 320w\" sizes=\"auto, (max-width: 880px) 100vw, 880px\" \/><\/a><\/p>\n<p><span style=\"font-weight: 400;\">In the sample, we have taken the values 10 &amp; 20 in the cells c1 &amp; c2.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Using the logical operators, we have formed the table accordingly. If the condition satisfies, then it results as true in the cell or else it results as false.\u00a0\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">If you want to perform more than one calculation in a cell, then, there comes the role of the precedence table.<\/span><\/p>\n<h3>11. Precedence Table in MS Excel<\/h3>\n<p><span style=\"font-weight: 400;\">When there are more than two computations in a formula of a cell, there comes the role of a precedence table. The order of precedence plays a role while computing a complex formula.\u00a0<\/span><\/p>\n<table>\n<tbody>\n<tr>\n<td><b>Precedence Order<\/b><\/td>\n<td><b>Operator<\/b><\/td>\n<td><b>Operation<\/b><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">1<\/span><\/td>\n<td><span style=\"font-weight: 400;\">&#8211;<\/span><\/td>\n<td><span style=\"font-weight: 400;\">Negation<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">2<\/span><\/td>\n<td><span style=\"font-weight: 400;\">%<\/span><\/td>\n<td><span style=\"font-weight: 400;\">Percent<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">3<\/span><\/td>\n<td><span style=\"font-weight: 400;\">^<\/span><\/td>\n<td><span style=\"font-weight: 400;\">Power<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">4<\/span><\/td>\n<td><span style=\"font-weight: 400;\">* , \/<\/span><\/td>\n<td><span style=\"font-weight: 400;\">Multiplication &amp; Division(In these both operations, whichever comes first will take the precedence.)<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">5<\/span><\/td>\n<td><span style=\"font-weight: 400;\">+,-<\/span><\/td>\n<td><span style=\"font-weight: 400;\">Addition &amp; Subtraction(In these both operations, whichever comes first will take the precedence.)<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">6<\/span><\/td>\n<td><span style=\"font-weight: 400;\">&amp;<\/span><\/td>\n<td><span style=\"font-weight: 400;\">Concatenation<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">7<\/span><\/td>\n<td><span style=\"font-weight: 400;\">&gt;, &lt;, &gt;=, &lt;=, =<\/span><\/td>\n<td><span style=\"font-weight: 400;\">Comparison<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h3>Changing the order of the performance in MS Excel<\/h3>\n<p><span style=\"font-weight: 400;\">If we want to change the order of performance, then those values can be given in the brackets. If the values are provided in the parentheses then those values will be computed first.\u00a0<\/span><\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/change-in-performance.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-92731\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/change-in-performance.png\" alt=\"Precedence in MS Excel\" width=\"869\" height=\"376\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/change-in-performance.png 869w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/change-in-performance-300x130.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/change-in-performance-150x65.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/change-in-performance-768x332.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/change-in-performance-720x312.png 720w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/change-in-performance-520x225.png 520w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/change-in-performance-320x138.png 320w\" sizes=\"auto, (max-width: 869px) 100vw, 869px\" \/><\/a><\/p>\n<p><span style=\"font-weight: 400;\">From the sample, we can understand that the parentheses are computed first and then the other value.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">In cell c8, the products of A3, A4 are found and then they are added up with A2.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">In cell C9, the sum of A2, A3 are found and then they are multiplied by A4.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">As In cell C10, there were no parentheses found and so it has followed the precedence order. In between the multiplication and addition, the multiplication has higher precedence and so the values in the A3, A4 cells are multiplied first. And then, they are added with the value in cell A2.<\/span><\/p>\n<h3>Alternative ways to perform calculations in MS Excel<\/h3>\n<p><span style=\"font-weight: 400;\">There are also other ways to perform calculations in MS- excel. They are: <\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Using the AutoSum Function<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Through the Insert Function<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Using the Formulae from the group<\/span><\/li>\n<\/ul>\n<h4>1. Using the AutoSum function in MS Excel<\/h4>\n<p><span style=\"font-weight: 400;\">To use the autosum function for calculations, follow the below steps:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Click on the <\/span><b>Home<\/b><span style=\"font-weight: 400;\"> tab.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Go to the<\/span><b> AutoSum<\/b><span style=\"font-weight: 400;\"> option and click on the dropdown menu to choose the required function.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Click on the function and start performing the calculation.<\/span><\/li>\n<\/ul>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/autosum-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-92750\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/autosum-1.png\" alt=\"autosum function in MS Excel\" width=\"1904\" height=\"354\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/autosum-1.png 1904w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/autosum-1-300x56.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/autosum-1-1024x190.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/autosum-1-150x28.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/autosum-1-768x143.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/autosum-1-1536x286.png 1536w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/autosum-1-720x134.png 720w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/autosum-1-520x97.png 520w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/autosum-1-320x59.png 320w\" sizes=\"auto, (max-width: 1904px) 100vw, 1904px\" \/><\/a><\/p>\n<p>Now, Let&#8217;s have a glance at the functions in autosum and what they perform:<\/p>\n<table>\n<tbody>\n<tr>\n<td><b>Function<\/b><\/td>\n<td><b>Formula<\/b><\/td>\n<td><b>Syntax<\/b><\/td>\n<td><b>Description<\/b><\/td>\n<\/tr>\n<tr>\n<td><b>Sum<\/b><\/td>\n<td><span style=\"font-weight: 400;\">Sum()<\/span><\/td>\n<td><span style=\"font-weight: 400;\">=sum(start cell: end cell)<\/span><\/td>\n<td><span style=\"font-weight: 400;\">It calculates the sum of the cells.<\/span><\/td>\n<\/tr>\n<tr>\n<td><b>Average<\/b><\/td>\n<td><span style=\"font-weight: 400;\">Average()<\/span><\/td>\n<td><span style=\"font-weight: 400;\">=Average(start cell:end cell)<\/span><\/td>\n<td><span style=\"font-weight: 400;\">It calculates the<\/span> <span style=\"font-weight: 400;\">average of the cells.<\/span><\/td>\n<\/tr>\n<tr>\n<td><b>Count Numbers<\/b><\/td>\n<td><span style=\"font-weight: 400;\">Count()<\/span><\/td>\n<td><span style=\"font-weight: 400;\">=count(start cell: end cell)<\/span><\/td>\n<td><span style=\"font-weight: 400;\">It counts the total number of cells.<\/span><\/td>\n<\/tr>\n<tr>\n<td><b>Max<\/b><\/td>\n<td><span style=\"font-weight: 400;\">Max()<\/span><\/td>\n<td><span style=\"font-weight: 400;\">=Max(Start cell: End cell)<\/span><\/td>\n<td><span style=\"font-weight: 400;\">It picks the cell which has maximum value in it.\u00a0<\/span><\/td>\n<\/tr>\n<tr>\n<td><b>Min<\/b><\/td>\n<td><span style=\"font-weight: 400;\">Min()<\/span><\/td>\n<td><span style=\"font-weight: 400;\">=Min(Start cell: End cell)<\/span><\/td>\n<td><span style=\"font-weight: 400;\">It picks the cell which has minimum value in it.<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h3>Sum using AutoSum Function:<\/h3>\n<p><span style=\"font-weight: 400;\">To calculate the sum using autosum function, f<\/span><span style=\"font-weight: 400;\">ollow the below steps:<\/span><\/p>\n<p><span style=\"font-weight: 400;\">STEP-1: Click on the home tab and choose the autosum function.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">STEP-2: Click on the drop-down option and choose sum.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">STEP-3: <\/span><span style=\"font-weight: 400;\">Once the function appears, then just drag to which all cells the function should apply.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">STEP-4: Press <\/span><b>ENTER.<\/b><\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/autosum-sum-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-92749\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/autosum-sum-1.png\" alt=\"autosum sum function in MS Excel\" width=\"1920\" height=\"383\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/autosum-sum-1.png 1920w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/autosum-sum-1-300x60.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/autosum-sum-1-1024x204.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/autosum-sum-1-150x30.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/autosum-sum-1-768x153.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/autosum-sum-1-1536x306.png 1536w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/autosum-sum-1-720x144.png 720w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/autosum-sum-1-520x104.png 520w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/autosum-sum-1-320x64.png 320w\" sizes=\"auto, (max-width: 1920px) 100vw, 1920px\" \/><\/a><\/p>\n<p><span style=\"font-weight: 400;\">In the above sample, C3 holds the sum value using the sum function in AutoSum.<\/span><\/p>\n<h3>Average using AutoSum Function:<\/h3>\n<p><span style=\"font-weight: 400;\">If you want to calculate the average using autosum, follow the steps as below:<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Step -1: Choose the cell.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Step -2: Click on the home tab and navigate to the autosum.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Step-3: Click on the drop-down option in autosum. Choose average function.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Step -4: Drag the cells to which the function should apply.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Step-5: Then, press enter.<\/span><\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/autosum-average-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-92748\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/autosum-average-1.png\" alt=\"autosum average function in MS Excel\" width=\"1878\" height=\"379\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/autosum-average-1.png 1878w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/autosum-average-1-300x61.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/autosum-average-1-1024x207.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/autosum-average-1-150x30.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/autosum-average-1-768x155.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/autosum-average-1-1536x310.png 1536w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/autosum-average-1-720x145.png 720w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/autosum-average-1-520x105.png 520w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/autosum-average-1-320x65.png 320w\" sizes=\"auto, (max-width: 1878px) 100vw, 1878px\" \/><\/a><\/p>\n<p><span style=\"font-weight: 400;\">From the sample, we can see that C5 ho<\/span><span style=\"font-weight: 400;\">lds the average value of A2 to A6 using the average function in AutoSum.\u00a0<\/span><\/p>\n<h3>Max, Min, and Count Numbers Functions using AutoSum:<\/h3>\n<p><span style=\"font-weight: 400;\">Let\u2019s have a quick look at how the max, min, and count numbers functions work.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">To compute these above functions, the steps to follow will be the same. But make sure you choose the appropriate function before computing.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Below are the steps to follow to use an autosum function:<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Step -1: Choose the cell.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Step -2: Click on the home tab and navigate to the autosum.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Step-3: Click on the drop-down option in autosum. Choose the required function.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Step -4: Drag the cells to which the function should apply.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Step-5: Then, press enter.<\/span><\/p>\n<p><strong>Count Numbers:<\/strong><\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/count-numbers.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-92735\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/count-numbers.png\" alt=\"count numbers in MS Excel\" width=\"486\" height=\"268\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/count-numbers.png 486w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/count-numbers-300x165.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/count-numbers-150x83.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/count-numbers-320x176.png 320w\" sizes=\"auto, (max-width: 486px) 100vw, 486px\" \/><\/a><\/p>\n<h4>From the sample, we can see that the B7 cell holds the count of the number of values from A2 to A6 cells.<a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/max.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-92736\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/max.png\" alt=\"finding max in MS Excel\" width=\"488\" height=\"271\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/max.png 488w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/max-300x167.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/max-150x83.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/max-320x178.png 320w\" sizes=\"auto, (max-width: 488px) 100vw, 488px\" \/><\/a><\/h4>\n<h4>From the sample, we can observe that we have used the max function from autosum to show the maximum value from the list.<\/h4>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/min.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-92737\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/min.png\" alt=\"Min in MS Excel\" width=\"491\" height=\"272\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/min.png 491w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/min-300x166.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/min-150x83.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/min-320x177.png 320w\" sizes=\"auto, (max-width: 491px) 100vw, 491px\" \/><\/a><\/p>\n<h4>Here, we can observe that we have used the min function from autosum, to show the minimum value from the list<\/h4>\n<h4>2. Using INSERT Function<\/h4>\n<p><span style=\"font-weight: 400;\">One of the ways is to click on the <\/span><b>Formulas<\/b><span style=\"font-weight: 400;\"> tab and choose the<\/span><b> Insert Function<\/b><span style=\"font-weight: 400;\"> option.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Then a box appears with the list of functions.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">If you don\u2019t know the name of the function, then you can just search for the function in the place provided. And press<\/span><b> GO<\/b><span style=\"font-weight: 400;\">.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Else, if you have an idea about the function name then just click on it and press <\/span><b>OK.<\/b><\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/insert-function.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-92738\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/insert-function.png\" alt=\"insert function in MS Excel\" width=\"1000\" height=\"790\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/insert-function.png 1000w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/insert-function-300x237.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/insert-function-150x119.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/insert-function-768x607.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/insert-function-720x569.png 720w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/insert-function-520x411.png 520w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/insert-function-320x253.png 320w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><\/a><\/p>\n<h4>3. Using Formulae from the Group<\/h4>\n<p><span style=\"font-weight: 400;\">The other way to perform a calculation is to choose the formula from the groups provided in the MS Excel.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Click on the<\/span><b> Formulas <\/b><span style=\"font-weight: 400;\">tab and choose any of the groups relevant to your calculation.<\/span><\/p>\n<p><b>The groups in MS-Excel are:<\/b><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Recently Used<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Financial\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Logical<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Text<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Date &amp; Time<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Lookup &amp; Reference<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Math &amp; Trig<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">Each group contains the formulae related to their group name. <\/span><span style=\"font-weight: 400;\">The recently used group contains the formulae that are frequently used.<\/span><\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/formulas-group.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-92739\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/formulas-group.png\" alt=\"formulas group in MS Excel\" width=\"744\" height=\"152\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/formulas-group.png 744w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/formulas-group-300x61.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/formulas-group-150x31.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/formulas-group-720x147.png 720w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/formulas-group-520x106.png 520w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/formulas-group-320x65.png 320w\" sizes=\"auto, (max-width: 744px) 100vw, 744px\" \/><\/a><\/p>\n<h3>Summary<\/h3>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">From the above tutorial, we have understood that performing calculations in MS-Excel is quite simple and easy.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">The only thing that we have to remember is that we have to start an operation with an equal to (=) symbol if we are typing the function.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">We can also see what calculation we are performing in a cell by clicking on it. Formula bar helps you in viewing the calculation in a particular cell.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">There are many ways to perform calculations in MS Excel.<\/span><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>MS-Excel is one of the software tools developed by Microsoft for easy computation, visual insights of the data using the features provided by the MS-Excel. In this tutorial of \u201cWhat are Formulas and Calculations&#46;&#46;&#46;<\/p>\n","protected":false},"author":1,"featured_media":92741,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[24129],"tags":[24107,24108,24109,24110,24111,24112,24113,24114,24115,24116,24117,24118,24119,24120],"class_list":["post-92504","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-ms-excel","tag-addition-in-ms-excel","tag-autosum-function-in-ms-excel","tag-average-in-ms-excel","tag-calculations-in-ms-excel","tag-comparisons-in-ms-excel","tag-concatenation-in-ms-excel","tag-formulaes-in-ms-excel","tag-multiplication-division-in-ms-excel","tag-nth-root-in-ms-excel","tag-percent-in-ms-excel","tag-power-in-ms-excel","tag-precedence-table-in-ms-excel","tag-square-root-in-ms-excel","tag-subtraction-in-ms-excel"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Formulas and Calculations in MS-Excel - DataFlair<\/title>\n<meta name=\"description\" content=\"In MS Excel, a formula is expression that operates on values in a range of cells or a cell. Learn about calculations &amp; formulas in MS Excel.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/data-flair.training\/blogs\/formulas-and-calculations-in-ms-excel\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Formulas and Calculations in MS-Excel - DataFlair\" \/>\n<meta property=\"og:description\" content=\"In MS Excel, a formula is expression that operates on values in a range of cells or a cell. Learn about calculations &amp; formulas in MS Excel.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/data-flair.training\/blogs\/formulas-and-calculations-in-ms-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"DataFlair\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DataFlairWS\/\" \/>\n<meta property=\"article:published_time\" content=\"2021-04-29T08:27:39+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-04-29T09:03:03+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/Basic-Calculations-in-MS-Excel1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"DataFlair Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:site\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"DataFlair Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"16 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Formulas and Calculations in MS-Excel - DataFlair","description":"In MS Excel, a formula is expression that operates on values in a range of cells or a cell. Learn about calculations & formulas in MS Excel.","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:\/\/data-flair.training\/blogs\/formulas-and-calculations-in-ms-excel\/","og_locale":"en_US","og_type":"article","og_title":"Formulas and Calculations in MS-Excel - DataFlair","og_description":"In MS Excel, a formula is expression that operates on values in a range of cells or a cell. Learn about calculations & formulas in MS Excel.","og_url":"https:\/\/data-flair.training\/blogs\/formulas-and-calculations-in-ms-excel\/","og_site_name":"DataFlair","article_publisher":"https:\/\/www.facebook.com\/DataFlairWS\/","article_published_time":"2021-04-29T08:27:39+00:00","article_modified_time":"2021-04-29T09:03:03+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/Basic-Calculations-in-MS-Excel1.jpg","type":"image\/jpeg"}],"author":"DataFlair Team","twitter_card":"summary_large_image","twitter_creator":"@DataFlairWS","twitter_site":"@DataFlairWS","twitter_misc":{"Written by":"DataFlair Team","Est. reading time":"16 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/data-flair.training\/blogs\/formulas-and-calculations-in-ms-excel\/#article","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/formulas-and-calculations-in-ms-excel\/"},"author":{"name":"DataFlair Team","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/b49855299264df5e27e3ec6c2cd9fde9"},"headline":"Formulas and Calculations in MS-Excel","datePublished":"2021-04-29T08:27:39+00:00","dateModified":"2021-04-29T09:03:03+00:00","mainEntityOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/formulas-and-calculations-in-ms-excel\/"},"wordCount":2632,"commentCount":0,"publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/formulas-and-calculations-in-ms-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/Basic-Calculations-in-MS-Excel1.jpg","keywords":["Addition in MS Excel","Autosum function in MS Excel","Average in MS Excel","Calculations in MS Excel","Comparisons in MS Excel","Concatenation in MS Excel","Formulaes in MS Excel","Multiplication &amp; Division in MS Excel","Nth Root in MS Excel","Percent in MS Excel","Power in MS Excel","Precedence Table in MS Excel","Square root in MS Excel","Subtraction in MS Excel"],"articleSection":["MS Excel Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/data-flair.training\/blogs\/formulas-and-calculations-in-ms-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/data-flair.training\/blogs\/formulas-and-calculations-in-ms-excel\/","url":"https:\/\/data-flair.training\/blogs\/formulas-and-calculations-in-ms-excel\/","name":"Formulas and Calculations in MS-Excel - DataFlair","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/formulas-and-calculations-in-ms-excel\/#primaryimage"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/formulas-and-calculations-in-ms-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/Basic-Calculations-in-MS-Excel1.jpg","datePublished":"2021-04-29T08:27:39+00:00","dateModified":"2021-04-29T09:03:03+00:00","description":"In MS Excel, a formula is expression that operates on values in a range of cells or a cell. Learn about calculations & formulas in MS Excel.","breadcrumb":{"@id":"https:\/\/data-flair.training\/blogs\/formulas-and-calculations-in-ms-excel\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/data-flair.training\/blogs\/formulas-and-calculations-in-ms-excel\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/formulas-and-calculations-in-ms-excel\/#primaryimage","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/Basic-Calculations-in-MS-Excel1.jpg","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/Basic-Calculations-in-MS-Excel1.jpg","width":1200,"height":628,"caption":"Basic Calculations in MS Excel"},{"@type":"BreadcrumbList","@id":"https:\/\/data-flair.training\/blogs\/formulas-and-calculations-in-ms-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog Home","item":"https:\/\/data-flair.training\/blogs\/"},{"@type":"ListItem","position":2,"name":"MS Excel Tutorials","item":"https:\/\/data-flair.training\/blogs\/category\/ms-excel\/"},{"@type":"ListItem","position":3,"name":"Formulas and Calculations in MS-Excel"}]},{"@type":"WebSite","@id":"https:\/\/data-flair.training\/blogs\/#website","url":"https:\/\/data-flair.training\/blogs\/","name":"DataFlair","description":"Learn Today. Lead Tomorrow.","publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/data-flair.training\/blogs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/data-flair.training\/blogs\/#organization","name":"DataFlair","url":"https:\/\/data-flair.training\/blogs\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","width":106,"height":48,"caption":"DataFlair"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataFlairWS\/","https:\/\/x.com\/DataFlairWS","https:\/\/www.linkedin.com\/company\/dataflair-web-services-pvt-ltd\/","https:\/\/www.youtube.com\/user\/DataFlairWS"]},{"@type":"Person","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/b49855299264df5e27e3ec6c2cd9fde9","name":"DataFlair Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/ef46b745ddad2fad690af626c6ef29b91809ad0a9f5ef398d07817d8cad042f5?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/ef46b745ddad2fad690af626c6ef29b91809ad0a9f5ef398d07817d8cad042f5?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ef46b745ddad2fad690af626c6ef29b91809ad0a9f5ef398d07817d8cad042f5?s=96&d=mm&r=g","caption":"DataFlair Team"},"description":"DataFlair Team is a group of passionate educators and industry experts dedicated to providing high-quality online learning resources on programming, Java, Python, C++, DSA, AI, ML, data Science, Android, Flutter, MERN, Web Development, and technology. With years of experience in the field, the team aims to simplify complex topics and help learners advance their careers. At DataFlair, we believe in empowering students and professionals with the knowledge and skills needed to thrive in today\u2019s fast-paced tech industry. Follow us for Free courses, expert insights, tutorials, and practical tips to boost your learning journey.","url":"https:\/\/data-flair.training\/blogs\/author\/datafbdad\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/92504","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/comments?post=92504"}],"version-history":[{"count":11,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/92504\/revisions"}],"predecessor-version":[{"id":92754,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/92504\/revisions\/92754"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media\/92741"}],"wp:attachment":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media?parent=92504"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/categories?post=92504"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/tags?post=92504"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}