[Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register]

Author Message
Knives3057
Newbie

Joined: 27 Feb 2012
Posts: 3

 Posted: Mon Feb 27, 2012 10:20 pm    Post subject: New to spreadsheet and need help 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
floris_v
Moderator

Joined: 12 Jul 2007
Posts: 4791
Location: Netherlands

 Posted: Tue Feb 28, 2012 12:19 am    Post subject: 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
Knives3057
Newbie

Joined: 27 Feb 2012
Posts: 3

 Posted: Tue Feb 28, 2012 12:43 am    Post subject: 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?
floris_v
Moderator

Joined: 12 Jul 2007
Posts: 4791
Location: Netherlands

 Posted: Tue Feb 28, 2012 1:16 am    Post subject: 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
Knives3057
Newbie

Joined: 27 Feb 2012
Posts: 3

 Posted: Tue Feb 28, 2012 1:26 am    Post subject: 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
floris_v
Moderator

Joined: 12 Jul 2007
Posts: 4791
Location: Netherlands

 Posted: Tue Feb 28, 2012 2:37 am    Post subject: 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
 Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First
 All times are GMT - 8 Hours Page 1 of 1

 Jump to: Select a forum OpenOffice.org Forums----------------Setup and TroubleshootingOpenOffice.org WriterOpenOffice.org CalcOpenOffice.org ImpressOpenOffice.org DrawOpenOffice.org MathOpenOffice.org BaseOpenOffice.org Macros and APIOpenOffice.org Code Snippets Community Forums----------------General DiscussionSite Feedback
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