LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #11   Report Post  
Posted to microsoft.public.excel.misc
Serge
 
Posts: n/a
Default Triangle solution, was IF, VLOOKUP & LOOKUP TABLE ON OTHER

Hello David,
Just to let you know, I was able to modified your formula as follows:
In E51
=IF(OR(A51="",B51="",C51=""),0,DEGREES(ATAN(A51*SI N(RADIANS(C51))/(B51-A51*COS(RADIANS(C51))))))

Thanks again
Serge

"David Biddulph" wrote:

"Serge" wrote in message
...

"David Biddulph" wrote:

"Serge" wrote in message
...
I'm working on another Triangle solution which I have a bit of trouble
with.
In E51=A51*SIN(RADIANS(C51))/B51-(A51*(COS(RADIANS(C51))))
To represent: tan A = a x sin C / b - (a x cos C)
a=25.0 in A51
b=21.5407 in B51
Angle C=42.03 Degrees in C51
Answer should be 79.935 degrees.

could you help with this one as well?

You need:
tan A = a x sin C / (b - (a x cos C)), noting the brackets around the b -
(a
* cos C) [and of course you don't strictly need the brackets around a *
cos
C].

E51=A51*SIN(RADIANS(C51))/(B51-A51*COS(RADIANS(C51)))
Your answer is =DEGREES(ATAN(E51)) which gives the 79.935 you were
looking
for.


Hello David,
Thanks for your reply.
It's not working for me. I copied the formula as it was written and pasted
it E51 and the answer I got was 5.63 degrees.
Is there something I'm missing?


Please read my reply again.

What you got in E51 was *not* 5.63 degrees. It was 5.63. E51 is the value
of tan A in your explanation above.
If you want the angle A in degrees, you need =DEGREES(ATAN(E51)) which gives
79.935.
--
David Biddulph



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to create a lookup table with an added varable? GIZZMO Excel Worksheet Functions 3 April 6th 09 10:32 PM
Vlookup a part of a cell value in another sheet Salman Excel Worksheet Functions 0 March 22nd 06 07:52 AM
Value between 2 dates AG Excel Worksheet Functions 11 August 21st 05 05:32 PM
Multiple worksheet queries liam Excel Worksheet Functions 3 February 16th 05 06:52 PM
Index table lookup anomaly Carole O Excel Worksheet Functions 9 December 9th 04 04:33 PM


All times are GMT +1. The time now is 10:17 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"