Thread: Microsoft Excel help
03-01-2004, 07:17 PM #1
Microsoft Excel help
Okay... it was suggested I use Microsoft Excel for a laboratory in which we need to input 15-some 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 TI-86 style calculator where you do something like this:
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?
03-02-2004, 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.
03-02-2004, 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?
03-02-2004, 09:31 AM #4
If you want the average of a column of numbers try this
If you can run them Down a column it would be easier to do this
03-02-2004, 09:36 AM #5Originally Posted by Commando_Barbi
One term is
(400 pi d [1/(g(sigma-rho))][(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?
03-02-2004, 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.
03-02-2004, 09:46 AM #7Originally Posted by Commando_Barbi
OMG the paperclip thingy moves!!!!
03-02-2004, 09:49 AM #8
03-02-2004, 09:50 AM #9
Does the scarey paperclip let you ask a question by typing in a box?
03-02-2004, 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.
03-02-2004, 09:55 AM #11Originally Posted by Commando_Barbi
03-02-2004, 09:57 AM #12
Ok....I'm trying to get him to join so he can answer your questions. Hell if I know
03-02-2004, 09:59 AM #13
Do you have yahoo msger ? He's on there and can chat with you about this.
03-02-2004, 10:07 AM #14Originally Posted by Commando_Barbi
03-02-2004, 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:
so, your formula should be:
IM me if you have any furtehr questions.
03-02-2004, 10:57 AM #16
Excellent!!! Thank you both. This should help a lot.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)