View Single Post
  #14   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph
 
Posts: n/a
Default Triangle solution, was IF, VLOOKUP & LOOKUP TABLE ON OTHER SHE

"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