A parallelogram is a quadrilateral in which the opposite sides are parallel and equal.
To calculate the area of a parallelogram, you multiply the base by the height:
Area = base * height
For example, if the base is 4 inches and the height is 6 inches then the area is calculated as:
Area = 4 inches * 6 inches = 24 inches2
The following example shows how to calculate the area of a parallelogram in Excel.
Example: How to Calculate Area of Parallelogram in Excel
To calculate the area of a parallelogram in Excel, you need to type the value for the height in one cell, the value for the base in another cell, and then simply multiply these two values together.
For example, if the value for the height is in cell C9 and the value for the base is in cell D9, then you can type the following formula into cell E9 to calculate the area of the parallelogram:
=C9*D9
The following screenshot shows how to use this formula in practice:
Cell E9 returns a value of 3.
Note that we simply clicked and dragged the formula in cell E9 down to each remaining cell in column E to calculate the area of various parallelograms with different values for the height and base.
For example:
- The area of a parallelogram with a height of 1 and base of 3 is 1*3 = 3
- The area of a parallelogram with a height of 2 and base of 4 is 2*4 = 8
- The area of a parallelogram with a height of 3 and base of 5 is 3*5 = 15
And so on.
Additional Resources
The following tutorials explain how to perform other common operations in Excel:
Excel: How to Multiply Column by a Percentage
Excel: How to Multiply Column by a Constant
Excel: How to Multiply Two Columns and then Sum
