If you want to calculate the area of a rectangle, triangle, or circle in Excel, here is how you can do that. It is possible to calculate the area of those shapes when certain values such as length, height, or radius is already given.
Calculate the area of a Rectangle in Excel
The basic formula for calculating the area of a rectangle in Excel is length * height. Thus, the syntax of the formula for finding the area of a rectangle in Excel would become:
=<cell with length>*<cell with height>
Eg. Let us assume we have a list of lengths of rectangles spread across column A from cell A3 to A11 and the heights of the rectangles spread across column B from B3 to B11. We need the area of the rectangle in column C from C3 to C11.
Now, the formula for the rectangle for C3 would become:
=A3*B3
You could use the Fill function to pull the formula down to C11. Simply click outside the cell C3 and back on it. Then use the fill button at the right bottom corner to pull the selection down to C11.
Calculate the area of a Triangle in Excel
The formula for calculating the area of a triangle is (length * height)/2. Thus, the syntax of the formula for finding the area of a triangle in Excel would become:
=(<cell with length>*<cell with height>)/2
Eg. Let us consider the length and height in columns A and B as in the previous example. We need the areas of the triangles in column D from D3 to D11.
Now, the formula for the triangles for C3 would become:
=(A3*B3)/2
You can use the Fill function as explained earlier to pull the formula down to D11.
Calculate the area of a Circle in Excel
The area of a circle is 3.14*(radius*radius). To create the formula in Excel, I could suggest the exponential function however, since the goal is just to find the square, we can twist the formula a little. The syntax to find the area of a circle in Excel is as follows:
=3.14*<cell with radius>*<cell with radius>
Eg, if we have the list of radii in column F from F3 to F11 and we need the areas of the circles in column G from G3 to G11, then the formula for cell G3 would become:
=3.14*F3*F3
You could use the Fill function to pull the formula down to cell G11.
Does this work?
Read: How to calculate Median in Excel
How to calculate the area of triangle in Excel?
To calculate the area of a triangle in Excel, you need to use this formula =(<cell with length>*<cell with height>)/2. If the length is given in the A1 cell and height in the B1 cell, you need to use the formula like this: =(A1*B1)/2. No matter how many cells there are with such values, you can calculate the area using the same formula.
How to calculate the area of a rectangle in Excel?
To calculate the area of a rectangle in Excel, you need to multiply the length with height. That being said, use this formula: =<cell with length>*<cell with height>. Let’s say that the length is given in the A1 cell and height in the B1 cell. You need to use the formula like this: =A1*B1.
Read: How to calculate Simple, Weighted, and Exponential Moving Averages in Excel
