LinkBack URL
About LinkBacks
how do i write the formular of pythagoras, I input a1^+a2^=c^ excel informs of an error I have also tried a1+a2^'c still errors can any body give me advice to what would seem such a simple input or am i misssining something here
how do i write the formular of pythagoras, I input a1^+a2^=c^ excel informs of an error I have also tried a1+a2^'c still errors can any body give me advice to what would seem such a simple input or am i misssining something here
Hi
With the two shorter sides of the right triangle in A1 & B1:
Rgds
Please Login or Register to view this content.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
thanx for the post worked much better but still somthing wrong. Here is the corect result for 2241.73^2 + 3.0^2 = 117.48 (mtrs) the result i get when written in excel cells is 2241.732007 which you notice has added 4 additional digits (2007)
here is the formular i have used as advised a1^2+b1^2 this formular is written in c1 once a again advice needed please
i also notice that the advised formular is for side (a) and side (b) of the right triangle I want the hypotenue angle as well
I have a given side (a) fig and I know the angle fig i need to know what the side (b) length is at connecting point (a)
Last edited by nivektta; 11-30-2009 at 11:04 AM. Reason: forgot to add some info
Seems to me that the square root of 2241.73^2 + 3.0^2 would be near to 2241.
As 9 is very small vs 2241, we may assume that we are calculating the sqrt of 2241.73^2 So the result you get as 2241.732007 is correct.
Try squaring 117 you will see what you get
ok if what you say is right could i ask you to look a t a web site
( http://www.1728.com/trig.htm) that has a pythag calculator on it although you cant see the guts code , and not sure if the page source gives to much away ,
I have been doing some reading and it would seem that the eqauastion is csq=asq+bsq C being the tan and B being side (1) horiz
the information I need to gather is side (A) length at any given point along side (B) with angle of 3.0 deg the calculator is much more detailed, i dont need any other of the calcs just the one mentioned
thanx again
Try downloading Handy 03 28 09.xls at and see if this helps:
http://sites.google.com/site/normay/excel-files
thought it was something diferent
did not see the tabs at the bottom spoke to soon will look at them
thanx
Last edited by nivektta; 11-30-2009 at 01:04 PM. Reason: spoke to soon
you are refering to sides as a,b when you should refer to them as either o,h,a .angles are referenced as A,B,C.... using those terms what are you trying to calculate?
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Martin, sides of a triangle might be called "O", "H" and "A" when in reference to a Sine/Cosine/Tangent formula (SOH-CAH-TOA), however the Pythagorean Theorem is specifically:
a² + b² = c²
Where "a" and "b" are the sides of the triangle, and "c" is the hypotenuse.
yep true but i just wanted clarification
also it looks likealong side (B)
whereas the op is using a formula ofangle of 3.0
2241.73^2 + 3.0^2
i suspect we need sine/cosine here but im not sure which angle op is refering to
Last edited by martindwilson; 12-01-2009 at 10:24 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks