Home | Community | Message Board


Myco Supply
Please support our sponsors.

Community >> The Pub

Welcome to the Shroomery Message Board! You are experiencing a small sample of what the site has to offer. Please login or register to post messages and view our exclusive members-only content. You'll gain access to additional forums, file attachments, board customizations, encrypted private messages, and much more!

Jump to first unread post. Pages: 1
Offlineendokrin
Stranger

Registered: 02/13/04
Posts: 142
Loc: SouthEast
Last seen: 8 years, 11 months
Microsoft Excel help
    #4107573 - 04/28/05 05:36 PM (11 years, 7 months ago)

Hi I'm doing a project for a class.
We're doing GDP forcasting.

I have to use all these formulas. I can choose two variables which affect the outcome. I have to find the values of these two variables which produce the smallest error.

Q-How do you set/store a variable in excel? (Like if I want to say X=3 and anywhere I have X in a formula it puts in 3. So I don't have to go through each formula and change every X until I get the answer)

Thanks


--------------------
"If King Kong sells drugs, we'll put him in jail"


Post Extras: Print Post  Remind Me! Notify Moderator
Invisibleafoaf
CEO DBK?
 User Gallery

Registered: 11/08/02
Posts: 32,665
Loc: Ripple's Heart
Re: Microsoft Excel help [Re: endokrin]
    #4107768 - 04/28/05 06:35 PM (11 years, 7 months ago)

put one set of values into individual cells in one column

put another set of values into individual cells in another column

create your formula using the first two cells in each of
these columns (solution in a third column)

then just copy that solution cell into each of the new solution
cells for all the other value pairs.

YOU WILL NOT HAVE TO MODIFIY THE FORMULA FOR EACH CELL!

excel is smart enough to replicate the formula using the
corresponding cells for this new solution cell based on
the pattern used in the original

for example:

Column A, rows 1-3

1
2
3

Column B, rows 1-3

4
5
6

Column C, row 1 = fx(A1+B1)

Value in C1 will be 5

copy C1 and paste into C2 and C3

the values in these cells will reflect the values
in A2/B2 and A3/B3, respectively

In this case, each cell stores a *variable*, really,
just a value (though the cell name could be considered
a variable to some degree) and as you replicate the
formula, excell uses it's structure to extrapolate what
it is you're trying to do in each of the new cells.


--------------------
All I know is The Growery is a place where losers who get banned here go.


Post Extras: Print Post  Remind Me! Notify Moderator
Jump to top. Pages: 1

Community >> The Pub

Similar ThreadsPosterViewsRepliesLast post
* Excel/Works Spreadsheet help demiu5 529 6 09/12/06 07:34 PM
by EndlessNameless
* excel help please
( 1 2 all )
LethalX5 1,198 31 09/11/05 01:08 PM
by InsatiableThirst
* microsoft office 2007 Leanin 648 15 01/07/08 10:02 AM
by mycopsycho
* Help with microsoft word / free typing programs PDU 745 10 02/08/06 02:54 PM
by Vvellum
* How to type Mathematic formulas in Word? stefan 452 7 04/10/05 08:39 AM
by stefan
* Microsoft uses Halo 2 to fuck chipped consoles
( 1 2 all )
OJK 2,942 33 11/13/04 05:56 PM
by Thor
* I need a Microsoft word-like program
( 1 2 all )
DIRTYMAN
1,347 24 02/22/07 09:05 PM
by VoidOfsPg
* excell question LethalX5 259 2 08/21/07 12:22 PM
by LethalX5

Extra information
You cannot start new topics / You cannot reply to topics
HTML is disabled / BBCode is enabled
Moderator: Entire Staff
339 topic views. 13 members, 120 guests and 76 web crawlers are browsing this forum.
[ Toggle Favorite | Print Topic | Stats ]
Search this thread:
Out-Grow.com - Mushroom Growing Kits & Supplies
Please support our sponsors.

Copyright 1997-2016 Mind Media. Some rights reserved.

Generated in 0.024 seconds spending 0.007 seconds on 14 queries.