## [Solved] Entering trig formula

Discuss the spreadsheet application

### [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

See attachment. Note that spreadsheet trigonometry uses radians for angle measure.
Attachments
trig.ods
(9.15 KiB) Downloaded 14 times

keme
Volunteer

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

### Re: Entering trig formula

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.
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 207 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: 6716
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
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
FJCC
Moderator

Posts: 7220
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

### 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

Return to Calc

### Who is online

Users browsing this forum: No registered users and 11 guests