Calculate the Area in Excel

In Excel, you may compute the area of a parallelogram by using a conventional formula and the multiplication operator.

To get the area of a circle, use the PI function and the exponent operator (). Excel has a standard set of arithmetic operators for performing addition, subtraction, multiplication, and exponentiation when composing formulae (raising to the power of). Furthermore, Excel has operators for cell ranges, range intersections, and implicit intersections.

calculate the area excel1

Explanation For Area of a parallelogram in Excel

A parallelogram is a four-sided quadrilateral form having two parallel pairs of sides. A parallelogram’s opposing sides are equal in length, and its opposite angles are equal in size. The area contained by a parallelogram in Euclidean geometry is determined by the formulaA=bh, where b denotes the base and h denotes the height.

Parallelogram Formula

As previously stated, a parallelogram is a two-dimensional structure that is studied in geometry. Each figure has its own set of attributes and settings. As a result, certain common formulae are provided for determining these characteristics.

The parallelogram formula is used to calculate both the area and perimeter of a parallelogram.


Area of Parallelogram

The area of a figure is defined as the whole surface area occupied by it, while the area of a parallelogram is defined as the surface area covered or occupied by it. Three distinct techniques are offered for calculating the area of a parallelogram. The area of a parallelogram may be calculated using the figure’s height, side lengths, or diagonals.

The same formula may be expressed in Excel as follows:


Thus, to get the area of a parallelogram with b equal to 10 and h equal to 20, we may use the following formula:

=10*20 //it returns 200

The objective of the example is to determine the area of eleven parallelograms by using the base value in column A and the height value in column B. The formula in C3 is as follows:


calculate the area excel1

Because both cells are entered as relative references, the method generates a different area for each successive row as it is copied along the table.

Explanation For Area of a circle in Excel

The area contained by a circle of radius (r) is defined in geometry by the following formula: πr2

The Greek letter (“pi”) denotes the ratio of a circle’s circumference to its diameter. In Excel, the PI function returns the value 3.141592654, which is accurate to 10 digits:

=PI() //yields a value of 3.141592654.

calculate the area excel1

In Excel, you may square an integer by using the exponentiation operator ():


calculate the area excel1

Alternatively, you may use the POWER function:


calculate the area excel1

By rewriting the formula =r2 as an Excel formula, we get the following:


calculate the area excel1



calculate the area excel1

Both formulae get the same outcome. Exponentiation occurs before multiplication in Excel’s sequence of operations.

How It Operates

Pi*Radius2 is the formula for the area of a circle, where Pi is a constant roughly equal to 3.14159265. Excel includes this constant as a function with no parameter inputs called PI ().

The POWER function takes any number and multiplies it by any other number. POWER(Radius,2) returns the Radius’s square. POWER(2,2) returns a value of 4, and 3.14159265*4 equals 12.56637 in our scenario.

Related Functions

  • Excel PI function
    The Excel PI function returns the value of mathematical constant PI. The returned value is 3.14159265358979 and ti will accurate to 15 digits.The syntax of the PI function is as below:=PI()…
  • Excel POWER function
    The Excel POWER function returns the result of a number raised to a given power.The syntax of the POWER function is as below:= POWER (number,power)….
Related Posts

Calculate Days Open in Excel

If you want to know how to Calculate days in Excel, there are some formulas that you can use to do so. For example, you can use the DAYS function in Excel to find the number of days between two ...

Calculate Grades With VLookup in Excel

Why Should You Calculate Grades With VLookup Excel? If you're looking for a simple way to find out a student's grades, VLOOKUP Excel can do the trick. This function uses a lookup table to find the values and sort them ...

Repeating Character n Times in Excel
Repeating Character n Times in Excel1

In daily life, we can use repeated characters to indicate the magnitude or priority of something. For example, a single “!” indicates a minor case, double “!!” indicates a medium case, and triple “!!!” indicates a high case, and so ...

Calculate Cumulative Loan Interest in Excel
calculate cumulative loan interest excel1

What is Cumulative Loan Interest? When comparing different types of loans, many people want to know what is Cumulative Loan Interest. The sum of all interest payments you've made on a loan is referred to as cumulative interest. Different lenders ...

Calculate Cumulative Loan Principal Payments in Excel
Calculate Compound loan principal payments excel1

How do you Calculate Cumulative Loan Principal Payments in Excel? There are a few different ways to calculate this information, but one way has been proven to be accurate more often than others. One option is to use the CUMPRINC ...

Trap Error or Replace Error by Specific Value with IFERROR function
Trap Error or Replace Error by Specific Value with IFERROR function1

We often use Excel formulas in our work life, and we may encounter this situation that the formula throws an error and finally an error like #DIV/0! Is displayed in the cell. In today’s tutorial, we will introduce you the ...

Calculate Compound Interest in Excel

This article will show you how to calculate compound interest in Excel. It will help you calculate the interest you will accrue on a given amount of money. There are several ways to calculate compound interest. One of the simplest ...

Count Attendance and Absence with COUNTIF function
Count Attendance and Absence1

In our campus life and work life, we usually record everyone's attendance. Today we will introduce you the application of Excel COUNTIF function to count the attendance. Using a week as an example, we use the following example to show ...

Find the Closest Data to the Data Provided in Excel

In our daily work, we may encounter such an issue that to find the closest value to a certain value. In fact, Excel internal functions can help us solve this problem. In today’s article, we will show you how to ...

Average Of Numbers With Multiple Criteria In Excel

Have you ever come across a task to calculate the average of the numbers with respect to multiple criteria? Are you tired of doing this cumbersome task manually? Are you willing to do this task smartly in just a matter ...