There is no built in function for solving these things. As you suggest, this is first a trig problem before it really becomes a programming problem. Here's what I see:
1) With AB and AW known, I know everything there is to know about right triangle ABW (not drawn) -- including length BW.
2) With BW, CW, and angle B known, I can solve for BC using the law of cosines:
https://en.wikipedia.org/wiki/Law_of_cosines Note that you will likely need the quadratic formula (
https://en.wikipedia.org/wiki/Quadratic_equation ) to solve for BC.
That's how I would probably solve this, though note that I have note yet found the intersection between AB and CW. If that is an important part of the overall problem, then further application of the law of cosines and other trig functions should allow you to solve for that point.
One important thing to note -- you have you angles written in degrees. Note that Excel's built in trig functions (like other programming languages) use angles in radians. As a mathematician, I might suggest that it is often easier to learn radians and become comfortable expressing angles in radians rather than degrees. Until you are comfortable with radians, you must recognize that there are "convert degrees to radians" and "convert radians to degrees" steps whenever you are working with trig functions.
Bookmarks