[Solved] Entering trig formula

[crabmann]

I have tried doing this but can't seem to get a handle on it.

In row 1 I want to enter a variable in A1, solve the cosine of that variable in A2,enter a constant in A3 and solve the sum of the cosine of the variable times the constant in A4. I want to repeat this with a variable value in column A. Example:

A-cos 30(Z)=
B-cos 45(Z)=
C-cos 60(Z)=...etc.

[keme]

See attachment. Note that spreadsheet trigonometry uses radians for angle measure.

[crabmann]

Thanks for your reply.

I downloaded your attachment but still cant seem to get it. Maybe it is because I don't know how to frame the formula. I wanted this to run horizontal and here is what I tried:
A1-30; A2-cosA1;A3-10 (variable);A4-cosA1*A3. The answer should be 8.66 but I get either an error message or NAME depending on how I characterize the formula. A little more guidance please.

[John_Ha]

Click the Function icon to open the Function Wizard or open Help and search with SIN. See Page 178 in the Calc Guide.

Code: Select all

=sin(1) gives sin of 1 radian which is 0.8414 ...
=sin(A6) gives sine of the number stored in A6

You will find much useful information in the User Guides, the Writer, Base and Calc Tutorials and the AOO Frequently Asked Questions. May I suggest you bookmark the pages.

Clipboard02.png (18.2 KiB) Viewed 1388 times

[crabmann]

I got it. My problem was that I was not putting Parentheses around my variable. I'm getting the wrong answer but I'm going in the right direction. For the cos of 30 I'm getting .15425 instead of .866.

Thanks for the input

[FJCC]

As noted above, the trig functions in Calc take their input in radians, not degrees. To get the cosine of 30 degrees use

Code: Select all

=COS(30 * PI()/180)

That is, convert degrees to radians by multiplying by pi and dividing by 180.

[crabmann]

GOT IT. I'M SET NOW. THANKS FOR ALL YOUR HELP.

CRABMANN