OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

New to spreadsheet and need help

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
Knives3057
Newbie
Newbie


Joined: 27 Feb 2012
Posts: 3

PostPosted: Mon Feb 27, 2012 10:20 pm    Post subject: New to spreadsheet and need help Reply with quote

I'm working on a calculus project and have the hard part done. But now I don't know how to get the formula I have to work in spreadsheet.
I need 3([sin^-1(d-1)+(d-1)sqrt(d(2-d))]-[sin^-1(-1)])*100 to input the numbers I have in the A column for d and I'm not quite sure how to do this. I keep trying different things but receive errors. Any help would be appreciated
Back to top
View user's profile Send private message
floris_v
Moderator
Moderator


Joined: 12 Jul 2007
Posts: 4791
Location: Netherlands

PostPosted: Tue Feb 28, 2012 12:19 am    Post subject: Reply with quote

If you need to evaluate a function f for a lot of values in column A, enter in =f(A1) in B1, then select all cells in B column to the bottom of the list in the A column, then select Edit - Fill - Down and it will copy the formula. Note that you need ASIN for the inverse of the Sine function, not Sin^-1.
_________________
LibreOffice 3.6.3; OOo 3.4.1 on Windows Vista
Join the Official community forum - in several languages, including Nederlandstalig forum
Back to top
View user's profile Send private message
Knives3057
Newbie
Newbie


Joined: 27 Feb 2012
Posts: 3

PostPosted: Tue Feb 28, 2012 12:43 am    Post subject: Reply with quote

Okay. Here's what I got so far. Know it's not right but I'm hoping I'm closing in
=f(A3)(300*([ASIN(x-1)+(x-1)*SQRT(x(2-x))]-[ASIN(-1)]))


Is this even close?
Back to top
View user's profile Send private message
floris_v
Moderator
Moderator


Joined: 12 Jul 2007
Posts: 4791
Location: Netherlands

PostPosted: Tue Feb 28, 2012 1:16 am    Post subject: Reply with quote

No, you have to be explicit about multiplication, and you can't use square brackets in formulas - they don't mean anything there. If you want to evaluate sin(x)/[1+cos(x)] for a number of values listed in the A column and put the outcomes in the B column, you need to put =sin(A3)/(1+cos(A3)) in B3. Really, read up on the basics of working with spreadsheets, that will help you infinitely more than any piecemeal help you can get in a forum.
_________________
LibreOffice 3.6.3; OOo 3.4.1 on Windows Vista
Join the Official community forum - in several languages, including Nederlandstalig forum
Back to top
View user's profile Send private message
Knives3057
Newbie
Newbie


Joined: 27 Feb 2012
Posts: 3

PostPosted: Tue Feb 28, 2012 1:26 am    Post subject: Reply with quote

I understand and thank u very much for your help but I hopefully won't need to do this again. It's a one time thing and I'm on a deadline for this morning
Back to top
View user's profile Send private message
floris_v
Moderator
Moderator


Joined: 12 Jul 2007
Posts: 4791
Location: Netherlands

PostPosted: Tue Feb 28, 2012 2:37 am    Post subject: Reply with quote

You'd get something like =3*Asin(A1-1) + (A1-1)*Sqrt(A1*(2-A1)))-Asin(-1)))*100 - but you will still need to straighten out brackets and things like that.
_________________
LibreOffice 3.6.3; OOo 3.4.1 on Windows Vista
Join the Official community forum - in several languages, including Nederlandstalig forum
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group