## [Solved] Entering trig formula

### [Solved] Entering trig formula

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.
Last edited by robleyd on Sun Jan 20, 2019 12:26 am, edited 1 time in total.
Reason: Tagged [Solved] [robleyd, Moderator]
Open Office 3.4.1 on Windows 8
crabmann

Posts: 28
Joined: Thu Dec 27, 2012 2:34 am

### Re: Entering trig formula

Attachments
trig.ods

keme
Volunteer

Posts: 3210
Joined: Wed Nov 28, 2007 10:27 am
Location: Egersund, Norway

### Re: Entering trig formula

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.
Open Office 3.4.1 on Windows 8
crabmann

Posts: 28
Joined: Thu Dec 27, 2012 2:34 am

### Re: Entering trig formula

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   Expand viewCollapse view
`=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 208 times
AOO 4.1.6, Windows 7 Home 64 bit

See the Writer Manual, the Writer FAQ, the Writer Tutorials and the Writer guide.

Remember: Always save your Writer files as .odt files. - see here for the many reasons why.
John_Ha
Volunteer

Posts: 6740
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK

### Re: Entering trig formula

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
Open Office 3.4.1 on Windows 8
crabmann

Posts: 28
Joined: Thu Dec 27, 2012 2:34 am

### Re: Entering trig formula

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   Expand viewCollapse view
`=COS(30 * PI()/180)`

That is, convert degrees to radians by multiplying by pi and dividing by 180.
Windows 10 and Linux Mint, since 2017
FJCC
Moderator

Posts: 7228
Joined: Sat Nov 08, 2008 8:08 pm

### Re: Entering trig formula

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

CRABMANN
Open Office 3.4.1 on Windows 8
crabmann

Posts: 28
Joined: Thu Dec 27, 2012 2:34 am