Question about Microsoft Excel for PC

1 Answer

1. calculation for excel spreadsheet macro for calculating the a right angle triangles hypotinuse and opposite side, angle given

Posted by on

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that gotĀ 5 achievements.

    Governor:

    An expert whose answer gotĀ voted for 20 times.

    Hot-Shot:

    An expert who has answered 20 questions.

  • Expert
  • 67 Answers

Hello this is Baris,
First off all when you say hypotinuse I think it is a 90 Degree triangle. Total of the angles off a triangle is 180 degree. So it is a simple algebra question.

Hypotinuse is 90
Right angle is R
Left angle is L
Total is 180

Equation is 90+ R +L = 180

We are looking for R, so lets arrange our equation.

R= 180 - 90 - L
R= 90 - L

This is our formula for excel

Lets put it in the excel
Type in A1 "hypotinuse "
Type in A2 "Left Angle"
Type in A3 "Right Angle"

Type in B1 90
Type in B2 "whatever the value given for the left angle"
Type in B3 =90-B2

As soon as you change the value in the cell B2, B3 will change by itself. Hope this helps :)


Posted on Oct 05, 2009

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

Formula to calculate hyportenuse


The formula to calculate the hypotenuse of a right angled triangle is a^2 + b^2 = c^2 or in words, a squared plus b squared is equal to c squared. The most common mistake is that students make the hypotenuse a squared or b squared. The hypotenuse has to be c squared. Thus, when figuring out the sides of a right-angled triangle, always make sure the hypotenuse is the longest side.

For example, a triangle with sides of length 3 and 4, calculate the hypotenuse. Let a be 3 and b be 4. 3^2 + 4^2 = c^2 or 9+16 = c^2, or 25 = c^2. Now take the square root of both sides and we get c = 5.

Feb 18, 2015 | Office Equipment & Supplies

1 Answer

How to find the length of a right angled triangle given the two sides remaining one


O^2 + A^2 = H^2 where

Opposite side
Adjacent side
Hypoteneuse

Oct 17, 2014 | Computers & Internet

1 Answer

How do you use CHASHOTAO to calculate the Hypotinus given the adjasent length and opposite angle


You should be aware that the adjective adjacent has no absolute meaning. It is relative to the angle you are considering.
Let some angle A in a right triangle. Let H be the measure of the hypotenuse. Do not confuse it with some height.
cos(A)=(measure of leg adjacent to A)/H
H= (measure of leg adjacent to A) / cos(A)
However what you call the opposite angle (the other angle I presume), is the complementary of of angle A. Call it angle B
In terms of that second angle
H=(measure of leg adjacent to A)/ sin(B)

What is adjacent to angle A is opposite to the complementary of A.
I think you should work a little more on the meaning of the words adjacent and opposite until you understand that they are relative concepts. They mean nothing until you spell out what angle you are looking at. Without proper understanding of these two concepts you will not be able to use correctly that mnemonic device which you have mangled (BTW)

I do not know it what language you have transcribed the mnemonic , but in English the device is called SOH- CAH-TOA

SOH means: To calculate the Sine of an angle divide the measure of the leg Opposite to the angle by the measure of the Hypotenuse.

CAH means: To calculate the Cosine of an angle divide the measure of the side Adjacent to the angle by the measure of the Hypotenuse.

TOA means: To calculate the Tangent of an angle divide the measure of the side Opposite to the angle by the measure of the side Adjacent to the angle.

Dec 10, 2013 | Computers & Internet

1 Answer

How do you inter the information to use the Sin, Cos, and Tan functions on the TI-30A?


There are several ways of doing this.

Opposite 12 and hypotenuse 13, so the sine of the angle is 12/13. Press 1 2 / 1 3 = 2nd [SIN^-1]

Adjacent 5 and hypotenuse 13, so the cosine of angle is 5/13. Press 5 / 1 3 = 2nd [COS^-1]

Adjacent 5 and opposite 12, so the tangent of the angle is 12/5. Press 1 2 / 5 = 2nd [TAN^-1].

Jun 08, 2012 | Texas Instruments TI-30XA Calculator

1 Answer

Given a length of 30 cm on the x axis and a length of 10 cm on the y axis and a angle of 90 at the x/y axis intersection is there a short cut to calculate interior angles and hypot. of the triangle?


Yes, there is shortcut because this is right triangle, so you can use Pythagorean theorem (see picture).
  1. Length of hypotenuse is square root of sum of squares of lengths of other two sides of triangle, which is equal to square root of 30^2+10^2=31.6 cm.
  2. Sin(a)=longer cathetus/hypotenuse=0.949 so a=arcsin(0.949)=71.6 degrees
  3. Finally b=90-a=18.4 degrees.
elessaelle.png

If this was helpful please rate 4 thumbs :)

Sep 05, 2011 | Texas Instruments TI-30XA Calculator

1 Answer

How to use Texas Instruments TI34II Calculator? Especially I want to now how to use sinus, cosinus, and tangen on it. In Indonesia we call it "sin, cos, tan" Need your help, thanks.


Sinus, cosinus, and tangens (Latin names) are the same as sine, cosine, and tangent (full English names), which are abbreviated to sin, cos, and tan. If you're asking how to use these functions, they deal with right triangles and finding the missing angles or side lengths of the triangle.

Always, sine equals opposite/hypotenuse, cosine equals adjacent/hypotenuse, and tangent equals opposite/adjacent.
king_cole.jpg

Using this picture, the sine of angle A equals a/c, the tangent of angle B equals b/a, and the cosine of angle A equals b/c, and so on.

In a calculator, simply hit the desired function (sin, cos, or tan), then in parenthesis put the measure of the angle, and then use what you know about the triangle to find out the rest.

Mar 03, 2011 | Texas Instruments 30XIISTKT1L1A Calculator

1 Answer

How do i use trigonometry to find out the angle in a triangle? which buttons do i press?


Sorry to say it, bu Mathematics is not Mathemagic: you cannot do things with the shaking of a wand.

There are several ways to find one angle in a right triangle when you have the measures of the sides. You must have the triangle drawn in front of you and then decide if you use the sine, the cosine or the tangent. I cannot presume to know what your triangle looks like.

I suggest you look at the definitions of the trigonometric ratios and find out what is given in your problem.

If you use a ratio to find the cosine, you can then use the arcsine function to find the angle.
If you use one particular ratio to find the sine, you can then use the arcsine to find the angle.

If you know two sides a and b and you know the angle (B) opposite side b, you can use the sine formula (sin(A)/a=sin(B)/b) to determine sin(A) then use the arcsine of the result to get angle A.

Do post a comment to this thread with the case you are trying to solve.

Nov 12, 2010 | Casio FX-9750GPlus Calculator

2 Answers

How do i use tan on my calculator


Tangent is a trigonometry term. It is used to find the Opposite/Adjacent ratio when given an angle measure in a right triangle. The proper syntax is tan(angle measure).

Dec 17, 2009 | Computers & Internet

1 Answer

I keep getting ERR:DOMAIN when ever i do the inverse sin


inverse sine (sin^-1) gives you the angle when the opposite side length and the hypotenuse, in relation to that angle, are given. therefore, if you want to do sin^-1(x), 0<x<1 for all real triangles ex. sin^-1(1/2) would equal 30. if you get a decimal, then go to [Mode] and select degrees instead of radians to get angle measures instead of radians... :)

Apr 23, 2009 | Texas Instruments TI-83 Plus Calculator

Not finding what you are looking for?
Microsoft Excel for PC Logo

247 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2658 Answers

Piyal Perera
Piyal Perera

Level 3 Expert

528 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18389 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...