3 Ways to Calculate Power / Square Numbers in Excel for Beginners

3 Ways to Calculate Power / Square Numbers in Excel for Beginners

Geekers - For certain purposes, we use exponential numbers to solve physics, chemistry, economics, mathematics and so on. For example, to calculate the area of the garden, predict agricultural yields, calculate pH, and others.


Is that a rank number? Exponential numbers are a simple form of repeated multiplication. Where, if a is a real number and n is an integer then the number a^n (read a to the power of n) is defined as the repeated multiplication of a as many as n times (factor).



So, a^n is called the exponential number, a is called the base number, and n is called the exponent.


Considering that Microsoft Excel is a program capable of processing numbers, it certainly provides several ways to calculate exponentials.


How to Calculate Power / Square Numbers


In Microsoft Excel, we can calculate numbers to the power of two (square), more than two or fractions. Of course, the method of calculation varies, therefore you must know and understand the various methods that can be used. For more details, let's look at the explanation on how to calculate exponents / squared numbers below:



List of contents

   * How to Calculate Power / Square Numbers

   + Method 1- Using the Multiplication Operator (*)

   + Way 2 – Using Accent (^)

   + Method 3 – Using the Power() Function


Method 1- Using the Multiplication Operator (*)


This method is very simple. You only need to use the multiplication operator (*) where you multiply the same number repeatedly according to the number to the specified power. For example, 9^3 = 9 * 9 * 9 = 243.


Notice the example below:


how to calculate exponential numbers with the multiplication operator how to calculate exponential numbers with the multiplication operator


In the above formula, we use reference cells as numbers to the power and power for example cell A2 (4) with the power B2 (2) becomes 4^2 and the result is 16. And so on up to A5.


Method 2 – Using Accent (^)


We can also use the accent operator (^) to calculate multiplication. The formula for calculating the rank in this way is:

(number)^(rank)


Information:

   * number is the number or value to be raised to the power.

   * rank is the sum of the powers of numbers such as powers of 2, 3 and so on.




An example of the formula above is:

   * 25^2 = 625, where find this the same as 25 * 25 = 625.

   * As for real exponents, for example for 30^5/2Â it becomes 30 ^ (5/2) or equal to 30 ^ 2.5.


Notice the example below:


how to calculate the square how to calculate the square


In the formula above, we use reference cells as numbers to the power and power for example cell A2 (25) with the power B2 (2) becomes 25^2 and the result is 625. And so on up to A5.


Method 3 – Using the Power() Function


Previously we used the multiplication (*) and accent (^) operators but now we will use a special function, namely POWER(). The formula for calculating the rank in this way is:

N^P = POWER(N,P)


Information:

   * N is the number or value to be raised to the power.

   * P is the number of powers of P such as powers 2, 3 and so on.


An example of the formula above is:

   * POWER(25, 2) = 625, which is the same as 25 ^ 2 and 25 * 25.

   * As for the real exponents, for example for 30^5/2 it becomes POWER(30, 5/2) or POWER(30, 2.5) Â or equal to 30 ^ 2.5. In short, the formula becomes:

=N^(P/D) or =POWER(N,P/D)


Notice the example below:


quadratic excel formula quadratic excel formula


In the formula above, we use reference cells as numbers to the power and power for example cell A2 (25) with the power B2 (2) becomes 25^2 and the result is 625. And so on up to A5.


That's all for the discussion this time about how to calculate exponents / square numbers in Microsoft Excel. Hopefully useful and good luck. Thank you!



Also Read:

   * How to Make a Number Receipt in Microsoft Excel

   * How to Protect Cells and Range in Ms. Excel

   * How to Hide Columns or Rows in Microsoft Excel

   * How to Hide Worksheets in Excel

Share:

Top Ads

Responsive Ads

Bottom Ads

Responsive Ads