Area of a triangle

=(b*h)/2
To calculate the area of a triangle in Excel, you can use the standard formula, adapted with Excel's math operators. In the example shown, the formula in C5, copied down, is:
=(B5*C5)/2
which calculates the area of a triangle given height from column B and base from column C.
In geometry, the area enclosed by a triangle is defined by this formula:
where b represents the base of the triangle, and h represents the height, measured at right angles to the base. In Excel, the same formula can be represented like this:
A=b*h/2
So, for example, to calculate the area of a triangle with a base of 4 and a height of 3:
=4*3/2 // returns 6
In the example shown, the goal is to calculate the area for eleven triangles with base given in column B and height given in column C. The formula in D5 is:
=(B5*C5)/2
As this formula is copied down the table, it calculates a different area at each new row.
Note: The parentheses in this formula are optional and for readability only. In Excel's order of operations, multiplication will occur before division, so the parentheses are unnecessary.
Download 200+ Excel Shortcuts
Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.