New to spreadsheet and need help

Knives3057 · Newbie Joined: 27 Feb 2012 Posts: 3

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

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

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