Jan 07 2021 07:01 AM
Jan 07 2021 08:13 AM
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
Jan 08 2021 06:09 AM
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:
Jan 08 2021 08:15 AM - edited Jan 09 2021 10:46 AM
Incorrect. Three typos and a translation mistake. Errata:
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:
[*] online calculator (click here)