Volume of Triangular Prism excel formula

%3CLINGO-SUB%20id%3D%22lingo-sub-2040237%22%20slang%3D%22en-US%22%3EVolume%20of%20Triangular%20Prism%20excel%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2040237%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20Can%20someone%20please%20create%20an%20excel%20formula%20for%20the%20follow%20equations%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22SMalloryMS_0-1610031409748.png%22%20style%3D%22width%3A%20381px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F244737i35FF4A53F7600E46%2Fimage-dimensions%2F381x47%3Fv%3D1.0%22%20width%3D%22381%22%20height%3D%2247%22%20role%3D%22button%22%20title%3D%22SMalloryMS_0-1610031409748.png%22%20alt%3D%22SMalloryMS_0-1610031409748.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22SMalloryMS_1-1610031438061.png%22%20style%3D%22width%3A%20384px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F244738i25A3EFA1903548AF%2Fimage-dimensions%2F384x43%3Fv%3D1.0%22%20width%3D%22384%22%20height%3D%2243%22%20role%3D%22button%22%20title%3D%22SMalloryMS_1-1610031438061.png%22%20alt%3D%22SMalloryMS_1-1610031438061.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2040237%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2040635%22%20slang%3D%22en-US%22%3ERe%3A%20Volume%20of%20Triangular%20Prism%20excel%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2040635%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F921199%22%20target%3D%22_blank%22%3E%40SMalloryMS%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ELet's%20say%20you%20enter%20the%20values%20for%20a%2C%20b%2C%20c%20and%20h%20in%20B1%2C%20B2%2C%20B3%20and%20B4%2C%20respectively.%3C%2FP%3E%0A%3CP%3EIn%20another%20cell%2C%20say%20B5%2C%20enter%20the%20formula%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3DB4%2F4*SQRT((B1%2BB2%2BB3)*(B2%2BB3-B1)*(B3%2BB1-B2)*(B1%2BB2-B3))%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3Eor%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3DB4%2F4*SQRT(-B1%5E2%2B2*(B1*B2)%5E2%2B2*(B1*B3)%5E2-B2%5E2%2B2*(B2*B3)%5E2-B3%5E2)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2043718%22%20slang%3D%22en-US%22%3ERe%3A%20Volume%20of%20Triangular%20Prism%20excel%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2043718%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F53148%22%20target%3D%22_blank%22%3E%40Man%20Fai%20Chan%3C%2FA%3E%26nbsp%3BYour%20formula%20worked!%20Thanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi, Can someone please create an excel formula for the follow equations:

 

SMalloryMS_0-1610031409748.png

SMalloryMS_1-1610031438061.png

 

 

4 Replies

@SMalloryMS 

Let's say you enter the values for a, b, c and h in B1, B2, B3 and B4, respectively.

In another cell, say B5, enter the formula

 

=B4/4*SQRT((B1+B2+B3)*(B2+B3-B1)*(B3+B1-B2)*(B1+B2-B3))

 

or

 

=B4/4*SQRT(-B1^2+2*(B1*B2)^2+2*(B1*B3)^2-B2^2+2*(B2*B3)^2-B3^2)

@SMalloryMS 

 

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!

@Hans Vogelaar 

=B4/4*SQRT(-B1^2+2*(B1*B2)^2+2*(B1*B3)^2-B2^2+2*(B2*B3)^2-B3^2)

 

Incorrect. Three typos and a translation mistake.  Errata:

=B4/4*SQRT(-(B1^4)+2*(B1*B2)^2+2*(B1*B3)^2-B2^4+2*(B2*B3)^2-B3^4)

 

Note:  In Excel, -B1^4 is parsed as (-B1)^4, which is always positive.  But in math, it is parsed as -(B1^4), which is always negative.

 

PS.... In selecting a, b and c, we must avoid SQRT returning #NUM because its parameter is negative.  An online calculate [*] specifies the following requirements:

a+b > c
a+c > b
b+c > a

One set of values that meets those conditions:

a: 123
b: 456
c: 543

 

[*] online calculator (click here)