Calculate the Area in Google Sheets

In Google Sheets, 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 (). Google Sheets has a standard set of arithmetic operators for performing addition, subtraction, multiplication, and exponentiation when composing formulae (raising to the power of). Furthermore, Google Sheets has operators for cell ranges, range intersections, and implicit intersections.

calculate the area in google sheets1

Explanation For Area of a parallelogram in Google Sheets

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 formula A=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 Google Spreadsheets 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 in google sheets1

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 Google Sheets

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 Google Sheets, the PI function returns the value 3.141592654, which is accurate to 10 digits:

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

calculate the area in google sheets1

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


calculate the area in google sheets1

Alternatively, you may use the POWER function:


calculate the area in google sheets1

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


calculate the area in google sheets1



calculate the area in google sheets1

Both formulae get the same outcome. Exponentiation occurs before multiplication in Google Sheets’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. Google Sheets 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

  • Google Sheets PI function
    The Google Sheets 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()…
  • Google Sheets POWER function
    The Google Sheets 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

Rank Numbers without Repetitive Ranks in google sheets

This article will guide you how to rank numbers in a range with unique ranking in google sheets. How to use the Rank function in google sheets to get a unique ranking for ranges with duplicate values. Ranking without Repetitive ...

Rank Numeric Values with Duplicate in Google Sheets

Suppose you have an urgent task of ranking a list with duplicate values, what would be the first approach you would think of? Is there a quick and easy way to do this task in Google Sheets? This article will ...

Calculate Compound Interest using FV Function in Google Sheets

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

Count Attendance and Absence with Google Sheets COUNTIF

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

Find the Closest Data to the Data Provided in Google Sheets

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

Basic Array Formula With Examples in Google Sheets

Are you searching for an article for getting the basic array formula with different examples for better understanding? Then congratulations because you have just landed on the right article. In this article, you would get to know the basic array ...

Average Of Numbers With Multiple Criteria in Google Sheets

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

Calculate Average Of Last 5 Or N Values In Columns in Google Sheets
Average last N values in columns in google sheets1

Suppose you come across a task where you need to calculate the average of the last 2 or 3 numeric values in google sheets, then what would you do? If you are new to google sheets, then your first attempt ...

Find And Retrieve Missing Values in Google Sheets
FIND AND RETRIEVE missing values1

Find and retrieve is a common basic operation in Google Sheets for tables. In out daily work, we may encounter this situation that some data was lost after several operations on a table in Google Sheets. In fact, we can ...

Calculating Average Of The Numbers in Google Sheets
_3 Average numbers in google sheets1

Are you weary of investing a lot of time and effort in manually calculating the average of the numbers by including or excluding 0 and calculating the average of the top 3 scores? Then congratulations because you have just landed ...