(Geometry)众所周知,几何使数学和计算变得容易。矩形,三角形和圆形等基本形状的面积可以使用某些公式计算。如果您需要计算一系列条目的基本形状的面积,Excel将非常有用。在本文中,我们解释了在Excel中计算矩形、圆形和三角形面积的过程。
在Excel中计算矩形的面积(Rectangle)
Excel中计算矩形面积的基本公式是:长*高。因此,在Excel(Excel)中求矩形面积的公式语法将变为:
=<cell with length>*<cell with height>
例如。假设我们有一个从单元格 A3 到A11跨列 A 分布的矩形长度列表,以及从 B3 到(A11)B11跨列 B 分布的矩形高度。我们需要 C 列中从 C3 到C11的矩形区域。
现在,C3 的矩形公式将变为:
=A3*B3
您可以使用Fill函数将公式下拉到C11。只需(Simply)在单元格 C3 外部单击并返回即可。然后使用右下角的填充按钮将选择下拉到C11。
在Excel中计算三角形的面积(Triangle)
三角形面积的计算公式是(长*高)/2。因此,在Excel(Excel)中求三角形面积的公式语法将变为:
=(<cell with length>*<cell with height>)/2
例如。让我们像前面的示例一样考虑 A 列和 B 列中的长度和高度。我们需要 D 列中从 D3 到D11的三角形面积。
现在,C3 的三角形公式将变为:
=(A3*B3)/2
您可以使用前面解释的Fill函数将公式下拉到D11。
Excel计算圆(Circle)的面积
圆的面积是 3.14*(radius*radius)。要在Excel(Excel)中创建公式,我可以建议使用指数函数,因为目标只是找到平方,我们可以稍微扭曲一下公式。Excel中求圆面积的语法如下:
=3.14*<cell with radius>*<cell with radius>
例如,如果我们有 F 列中从 F3 到F11的半径列表,并且我们需要 G 列中从 G3 到G11的圆的面积,那么单元格 G3 的公式将变为:
=3.14*F3*F3
您可以使用Fill函数将公式下拉到单元格G11。
这行得通吗?
How to calculate area of Rectangle, Triangle or Circle in Excel
Geometry is known to make mathematics and calculations easy. The area of basic shapes like rectanglе, triangle, and circle can be calculated using certаin fоrmulae. If you need to calculate the area of basic shaрes for a range of entrieѕ, Excel would be very useful. In this article, we have explained the procedure to calculate areas of a rectangle, circle, and triangle in Excel.
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?