top of page

How to do calculations in Excel?

Making calculations in Excel is easy. Here's how:

  • Type the equal symbol (=) in a cell. This tells Excel that you are entering a formula, not just numbers.

  • Type the equation you want to calculate. For example, to add up 5 and 7, you type =5+7

  • Press the Enter key to complete your calculation. Done!

Instead of entering numbers directly in your calculation formula, you can put them in separate cells, and then reference those cells in your formula, e.g. =A1+A2+A3


The following table shows how to perform basic arithmetic calculations in Excel.


The results of the above Excel calculation formulas may look something similar to this:









Apart from that, you can combine values from two or more cells in a single cell by using the concatenation operator (&) like this:


=A2&" "&B2&" "&C2


A space character (" ") is concatenated in between cells to separate the words:




You can also compare cells by using logical operators such as "greater than" (>), "less than" (<), "greater than or equal to" (>=), and "less than or equal to" (<=). The result of comparison are logical values of TRUE and FALSE:










The order in which Excel calculations are performed

When you do two or more calculations in a single formula, Microsoft Excel calculates the formula from left to right, according to the order of operations shown in this table:

Since the order of calculations affects the final result, you need to know how to change it.


How to change the order of calculations in Excel

Like you do in math, you can change the order of Excel calculations by enclosing the part to be calculated first in parentheses.


For example, the calculation =2*4+7 tells Excel to multiply 2 by 4, and then add 7 to the product. The result of this calculation is 15. By enclosing the addition operation in parentheses =2*(4+7), you instruct Excel to add up 4 and 7 first, and then multiply the sum by 2. And the result of this calculation is 22.


Another example is finding a root in Excel. To get the square root of, say, 16, you can use either this formula:

=SQRT(16)


or an exponent of 1/2:

=16^(1/2)


Technically, the above equation tells Excel to raise 16 to the power of 1/2. But why do we enclose 1/2 in parentheses? Because if we don't, Excel will raise 16 to the power of 1 first (an exponent operation is performed before division), and then divide the result by 2. Since any number raised to the power of 1 is the number itself, we would end up dividing 16 by 2. In contrast, by enclosing 1/2 in parentheses you tell Excel to divide 1 by 2 first, and then raise 16 to the power of 0.5.


As you can see in the screenshot below, the same calculation with and without parentheses produces different results:







This is how you make calculations in Excel. I thank you for reading and hope to see you on our blog next week!



Source: ablebits


The Tech Platform


0 comments

Comentários


bottom of page