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

Calculate areas of rectangle, triangle, and circle 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?

Calculate area of rectangle in Excel

Most Popular

Pew: 26% of U.S. adults get their news from YouTube

YouTube has emerged as a critical source of news for people in the U.S. as independent and traditional media sources attract massive audiences on...

NYMBUS Appoints Jeffery Kendall as New Chief Executive Officer

Banking Transformation Veteran to Lead Next Stage of Company Growth MIAMI–(BUSINESS WIRE)–September 28, 2020– NYMBUS®, a leading provider of banking technology solutions, today announced the Board...

Trump administration hits China’s largest chip manufacturer SMIC with sanctions

What just happened? Another Chinese tech firm is feeling the consequences of...

U.S. judge blocks Trump administration’s TikTok download ban

(Reuters) — A U.S. judge has temporarily blocked a Trump administration order that was set to bar Apple and Google from offering Chinese-owned short...

Recent Comments