Forum Discussion
Volume of Triangular Prism excel formula
Hi, Can someone please create an excel formula for the follow equations:
I would like to simplify the expression.
Suppose a, b, c, h are inputted in B1, B2, B3, B4.
Then in B5, input the formula "=SUM(B1:B3)"
In order to find the volume, you may consider the following formula:
=(B4/4)*SQRT(B5*(B5-2*B1)*(B5-2*B2)*(B5-2*B3))
Man Fai Chan Your formula worked! Thanks!
