PDA

View Full Version : Microsoft Excel formulas problem


Fobb
August 27th, 2006, 09:11 AM
I have run into a problem. I'm in an engineering class, and our first homework assignment is to figure out a few problems through the use of Excels formula solving system. I got the first question done with, but I can't seem to figure out the second one, let alone actually even have looking at the last one. The problem I have run into is this:
SIN^-1(A26(SIN(DEGREES(30)))/A26)

This is as far as I have gotten in figuring out the problem. I'm pretty sure that's it (the general idea anyways), but every time I try entering it, the program gives me errors telling me I did something wrong. I've checked the parenthesis, and this is exactly how the forumla is layed out for us to solve (the forumula is given on the assignment sheet). Can someone help me and tell me where I did anything wrong?

Suiko Eiji
August 27th, 2006, 09:24 AM
Needs more data, such as what are the contents of A26 and is 30 a special multiplier with degrees, or is it straight-up 30?

Granted, I stay out of physics and trig when working in Excel and OO Calc but what I find helps me is to work out the formula of each step I want to do on a scratch paper, input the data into the spreadsheet and then work the problem replacing instances of data with the appropriate cels.

Fobb
August 27th, 2006, 09:28 AM
It's not really a problem of the formula being the right one, but a problem of everything being in order. But just for you, the Contents of A26 are C in Inches. And 30 is one angle for the triangle we are supposed to be solving.

Suiko Eiji
August 27th, 2006, 09:45 AM
This may just be me being retarded ... but, did you leave out a multiplication command?

SIN^-1*(A26(SIN(DEGREES(30)))/A26)

Fobb
August 27th, 2006, 10:36 AM
That probably was it, but I figured it out. On top of that, degrees was supposed to be radians, so I kept getting negative answers. Thanks Suiko.

Suiko Eiji
August 27th, 2006, 10:57 AM
Ah, good deal. Good luck on the rest of your homework.

Fobb
August 27th, 2006, 10:57 AM
Thank you.