Thread: Microsoft Excel help

03012004, 07:17 PM #1
Microsoft Excel help
Okay... it was suggested I use Microsoft Excel for a laboratory in which we need to input 15some variables into a couple 'master equations'.
I have limited knowledge of this spreadsheet, so is there anything I need to know here? To my knowledge, it works kinda the same as the TI86 style calculator where you do something like this:
Square1A 88.9
Square1B 91.6
Square1C 3.79
then in square 1D input, for example, "=(1A+1B)/1C" and it gives me just that.
Is that all there is to it? Are there any complexities that may arise when doing something like this? Any special commands or anything?

03022004, 09:21 AM #2
I know I'm computer illiterate, but c'mon, someone lower themselves to my level so they can explain how this stupid spreadsheet works.

03022004, 09:23 AM #3
You can use the auto sum feature if all you are trying to do is add them. Is that what you are looking for?

03022004, 09:31 AM #4
If you want the average of a column of numbers try this
AVG=(A1+B1+C1)
If you can run them Down a column it would be easier to do this
AVG=(A1+A10)

03022004, 09:36 AM #5Originally Posted by Commando_Barbi
Example:
One term is
(400 pi d [1/(g(sigmarho))][(9 nu/2)^(1/2)])
Do I imput a formula like that, with each variable being inputed from a cell?
I've really never used Excel before, I am only guessing that it is like programming a calculator?

03022004, 09:41 AM #6
Sorry, I can't really tell you anymore than that. If you go to the help function it will tell you what functions are available. I've used it a LOT for work .... tracking budgets, etc....but you are well beyond my knowledge. I've used it to develop financial statements, etc.
Sorry

03022004, 09:46 AM #7Originally Posted by Commando_Barbi
OMG the paperclip thingy moves!!!!

03022004, 09:49 AM #8
Lmao

03022004, 09:50 AM #9
Does the scarey paperclip let you ask a question by typing in a box?

03022004, 09:54 AM #10
THis is from a engineer friend of mine. Does this answer your question?
For his answer though use the = to start input the formual and U should be able to take the variables from a table in Excel on another worksheet. I believe that should work if i remeber.

03022004, 09:55 AM #11Originally Posted by Commando_Barbi

03022004, 09:57 AM #12
Ok....I'm trying to get him to join so he can answer your questions. Hell if I know

03022004, 09:59 AM #13
Do you have yahoo msger ? He's on there and can chat with you about this.

03022004, 10:07 AM #14Originally Posted by Commando_Barbi

03022004, 10:42 AM #15Originally Posted by samoth
(1) you need to list the cells as A1, A2, etc, not as 1A, 1B as you indicate above.
(2) pi should be listed as PI().
FOr your formula above, I'll assume the variables are in the following cells:
d=A1
g=A2
sigma=A3
rho=A4
nu=A5
so, your formula should be:
=400*PI()*A1*(1/(A2(A3A4)))*((9*A5/2)^(1/2))
IM me if you have any furtehr questions.

03022004, 10:57 AM #16
Excellent!!! Thank you both. This should help a lot.
Thread Information
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Test Cyp,Dbol,Deca,tren stack for...
Today, 08:33 PM in ANABOLIC STEROIDS  QUESTIONS & ANSWERS