[Solved] Entering trig formula

Discuss the spreadsheet application

[Solved] Entering trig formula

Postby crabmann » Thu Jan 17, 2019 11:31 pm

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

Postby keme » Fri Jan 18, 2019 11:36 am

See attachment. Note that spreadsheet trigonometry uses radians for angle measure.
Attachments
trig.ods
(9.15 KiB) Downloaded 13 times
User avatar
keme
Volunteer
 
Posts: 3100
Joined: Wed Nov 28, 2007 10:27 am
Location: Egersund, Norway

Re: Entering trig formula

Postby crabmann » Sat Jan 19, 2019 12:35 am

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

Postby John_Ha » Sat Jan 19, 2019 2:41 am

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.

Clipboard01.jpg

Clipboard02.png
Clipboard02.png (18.2 KiB) Viewed 175 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: 6567
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK

Re: Entering trig formula

Postby crabmann » Sat Jan 19, 2019 4:13 am

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

Postby FJCC » Sat Jan 19, 2019 5:06 am

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: 7084
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: Entering trig formula

Postby crabmann » Sat Jan 19, 2019 8:49 pm

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 32 guests