Using the Pythagorean Theorem (c2 = a2 + b2), sorry if I am not using the correct terms! ;-)

To calculate the length of the oblique side of a right angle (hypotenuse)

Cell A1 is the Height (or Base), Cell B1 is the Base (or Height), in Cell C1 enter this formula.

=SQRT(POWER(A1,2)+POWER(B1,2))

To calculate the length of one of the right angle sides, (assuming you know the other side plus the oblique side (hypotenuse))

Cell A1 is the Height (or Base), Cell C1 is the hypotenuse, in Cell B1 enter this formula.

=SQRT(POWER(C1,2)-POWER(A1,2))

© Copyright
andrewsexceltips.net All Rights Reserved.