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

Registered: 02/13/04
Posts: 142
Loc: SouthEast
Last seen: 10 years, 5 months
Microsoft Excel help
    #4107573 - 04/28/05 05:36 PM (13 years, 1 month 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)


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

Post Extras: Print Post  Remind Me! Notify Moderator
 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 (13 years, 1 month 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.


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


Column B, rows 1-3


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 help plz Platinum 284 6 05/20/09 03:30 PM
by circularvortex
* Excel/Works Spreadsheet help demiu5 559 6 09/12/06 07:34 PM
by EndlessNameless
* excel help please
( 1 2 all )
LethalX5 1,451 31 09/11/05 01:08 PM
by InsatiableThirst
* microsoft office 2007 Leanin 707 15 01/07/08 10:02 AM
by mycopsycho
* Help with microsoft word / free typing programs PDU 803 10 02/08/06 02:54 PM
by Vvellum
* How to type Mathematic formulas in Word? stefan 521 7 04/10/05 08:39 AM
by stefan
* Microsoft uses Halo 2 to fuck chipped consoles
( 1 2 all )
OJK 4,108 33 11/13/04 05:56 PM
by Thor
* I need a Microsoft word-like program
( 1 2 all )
1,545 24 02/22/07 09:05 PM
by VoidOfsPg

Extra information
You cannot start new topics / You cannot reply to topics
HTML is disabled / BBCode is enabled
Moderator: Entire Staff
377 topic views. 11 members, 80 guests and 52 web crawlers are browsing this forum.
[ Toggle Favorite | Print Topic | Stats ]
Search this thread:
Crestline Sales - MycoPath
Please support our sponsors.

Copyright 1997-2018 Mind Media. Some rights reserved.

Generated in 0.026 seconds spending 0.007 seconds on 19 queries.