Home OS Windows How to calculate area of Rectangle, Triangle or Circle in Excel

How to calculate area of Rectangle, Triangle or Circle in Excel

Geometry is known to make arithmetic and calculations simple. The area of elementary shapes like rectangle, triangle, and circle shall be calculated using positive formulae. If it’s essential to calculate the realm of elementary shapes for a diffusion of entries, Excel will be very useful. In this textual content, we have outlined the method to calculate areas of a rectangle, circle, and triangle in Excel.

Calculate the realm of a Rectangle in Excel

The elementary formulation for calculating the realm of a rectangle in Excel is: dimension * peak. Thus, the syntax of the formulation for finding the realm of a rectangle in Excel would flip into:

=<cell with dimension>*<cell with peak>

Eg. Let us assume we have an inventory of lengths of rectangles unfold all through column A from cell A3 to A11 and the heights of the rectangles unfold all through column B from B3 to B11. We need the realm of the rectangle in column C from C3 to C11.

Now, the formulation for the rectangle for C3 would flip into:

=A3*B3

You might use the Fill function to drag the formulation all the way in which down to C11. Simply click on on outside the cell C3 and once more on it. Then use the fill button on the correct bottom nook to drag the selection all the way in which down to C11.

Calculate the realm of a Triangle in Excel

Calculate area of triangle in Excel


The formulation for calculating the realm of a triangle is (dimension * peak)/2. Thus, the syntax of the formulation for finding the realm of a triangle in Excel would flip into:

=(<cell with dimension>*<cell with peak>)/2

Eg. Let us take into consideration the scale and peak in columns A and B as inside the earlier occasion. We need the areas of the triangles in column D from D3 to D11.

Now, the formulation for the triangles for C3 would flip into:

=(A3*B3)/2

You can use the Fill function as outlined earlier to drag the formulation all the way in which down to D11.

Calculate the realm of a Circle in Excel

Area of Circle in Excel

The area of a circle is 3.14*(radius*radius). To create the formulation in Excel, I could counsel the exponential function nonetheless, as a result of the target is just to get your hands on the sq., we’ll twist the formulation considerably. The syntax to get your hands on the realm of a circle in Excel is as follows:

=3.14*<cell with radius>*<cell with radius>

Eg, if we have the guidelines of radii in column F from F3 to F11 and we wish the areas of the circles in column G from G3 to G11, then the formulation for cell G3 would flip into:

=3.14*F3*F3

You might use the Fill function to drag the formulation all the way in which down to cell G11.

Does this work?

Most Popular

Recent Comments