answersLogoWhite

0


Best Answer

You need to find the unknown base. Draw a right triangle, with the vertical height "h". By trigonometry, half the base, divided by "h", is equal to tan(alpha/2), where "alpha" is the angle. Therefore, the base "b" is equal to 2*h*tan(alpha/2), and the Excel formula for the area, (1/2)bh, is 0.5*2*h*tan(alpha/2)*h, which can be simplified to:h^2*tan(alpha/2)

Note 1: You must replace "h" and "alpha" with the correct values, or references to the cells that contain those values.

Note 2: Excel assumes that all angles are in radians. If the angles are in degrees, replace alpha with radians(alpha), to convert the angle.

User Avatar

Wiki User

8y ago
This answer is:
User Avatar
More answers
User Avatar

Wiki User

8y ago

the height h is perpendicular to the base b making a right angle so the tangent of half the top angle Q is b/2h

b = 2htan (Q/2)

This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: What is the formula to find the base of a isosceles triangle from the vertical height and top angle in excel assuming the known angle is at the top the base height is at the bottom and you don't know?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Continue Learning about Other Math
Related questions

What is the formula for isosceles?

do you want to know the area in a isosceles triangle or what?


What is the circumradius of an isosceles triangle?

To find the circumradius of an isosceles triangle, the formula is:1/8[(a^2/h)+4h]in which h is the height of the triangle and a is the base of the triangle.


How can the distance formula help you determine if the triangle is scalene isosceles or equilateral?

Use the distance formula to calculate the distances between the three vertices. If they are all different, the triangle is scalene, if only two are the same, the triangle is isosceles, and if they are all the same, the triangle is equilateral.


Can a right triangle also be an isosceles triangle or can it be an equilateral triangle explain?

A right triangle can be an isosceles triangle, because the definition of an isosceles triangle is a triangle that has 2 sides equal to each other. A 45,45,90 degree triangle has 2 sides equal to each other, while the hypotenuse is different. It cannot be an equilateral triangle because of the formula a^2+b^2=c^2. With this formula, there is no possible way that: a, b, and c can all be equal to each other. To recap: It can be an isosceles triangle, but not an equilateral one.


What is the formula for the area of an isosceles triangle?

The are of any triangle is calculated by the formula: Area = 1/2 x Base x Height


What is the formula to determine how many parallelograms there are in an isosceles triangle made up of 9 smaller but equally sized isosceles triangles?

There are normally no parallelograms within an isosceles triangle unless you put them there yourself.


What is the Formula of a hypotenuse of right triangle?

The hypotenuse of an isosceles right triangle is 13 centimeters long. How long are its sides?


What is the formula to determine how many parallelograms there are in an isosceles triangle made up of smaller isosceles triangles of the same size?

An isosceles triangle can be divided into 4 smaller, identical isosceles triangles. Each of these can then be divided into 4, and each of them ... So, the answer to the question is infinitely many.


Formula of perimeter of isosceles triangle?

Lengths of: equal side+equal side+base = perimeter


How do i find the base of an isosceles triangle from the vertical height and top angle in excel assuming the known angle is at the top the base height is at the bottom and you don't know the slant?

Well, if you just bisect the angle at the top to get two equivalent triangles, then you solve for half of the original base from (half base)/(vertical side) = tan(angle). The formula is for the base length is thus 2 × vertical_height × tan(top_angle ÷ 2) Assuming the top angle in degrees is in cell B1 Assuming the vertical height is in cell B2 Assuming you want the base length in cell B3, then in cell B3 put the formula: =2*B2*TAN(B1/2) You will need to format the cell to give the required degree of accuracy (eg 1 dp).


What is the formula to find the area of an isosceles triangle?

For all triangles: area = 1/2 * base * height


How do you find the hypoteneuse of an isosceles right triangle?

It is very unlikely for a right angle triangle to be isosceles, however it is possible if the angles are 90, 45, and 45 degrees. It does not matter if the triangle is isosceles, this method works for all right triangles. The following formula is your answer, when h=hypotenuse, and a and b are other two sides. a2 + b2 = h2