Learning Excel
 

In an effort to learn excel better, I thought I'd apply my studies to
various hobbies I undertake.

Current hobby: Fantasy Basketball. (btw, I wish all a good round of
betting, etc)

I've decided to create a player value based on current statistics
multiplied by a multiple that is based on the average of statistics
over the past 10 years.

For example, I've decided that points are rather common and the
multiple for points would be 1. Steals on the otherhand are much more
rare and float between 10-13 times less than the ability to score 2
points. This 10-13 is my 'multiple". I take all the current stats and
then multiply then to the various multiples in the categories.

I.e.

I have data in cells row F3 through I3
I wish to multiple each of these cells to a "multiple" as described
above on another sheet in cells A2 through D2 respectively. (F3 to A2,
G3 to B2, etc)

This works out fine.

Then I have data in cells row F4 through I4.
When I take the formula, the the excel takes my formula and chances
F3-I3 to F4 and I4, but changes A2 through D2 to A3 through D3. (F4 to
A3, G4 to B3)

I would like the row to change for my data, but the multiple reference
in the formula to remain.

Can anyone help this new kid on excel?

Thanks.

Learning Excel
 

I think you need to understand relative versus absolute referencing in
formulas. Fortunately it's pretty simple. It doesn't affect how a formula
works; it only affects how it copies/pastes.

A '$' before a row reference or column reference keeps it constant after a
copy/paste:

So =A1 copied down one row becomes =A2.
=A$1 copied down one row stays =A$1

=A$1 copied across one column becomes =B$1 but
=$A1 copied across one column stays =$A1

=$A$1 stays the same whether copied down or across.

When entering formulas in a cell you can press the F4 key to cycle through
the referencing possibilities. (Type "=" then click on a cell and then
press F4 several times to see this).

--
Jim
"georgeous" wrote in message
oups.com...
| In an effort to learn excel better, I thought I'd apply my studies to
| various hobbies I undertake.
|
| Current hobby: Fantasy Basketball. (btw, I wish all a good round of
| betting, etc)
|
| I've decided to create a player value based on current statistics
| multiplied by a multiple that is based on the average of statistics
| over the past 10 years.
|
| For example, I've decided that points are rather common and the
| multiple for points would be 1. Steals on the otherhand are much more
| rare and float between 10-13 times less than the ability to score 2
| points. This 10-13 is my 'multiple". I take all the current stats and
| then multiply then to the various multiples in the categories.
|
| I.e.
|
| I have data in cells row F3 through I3
| I wish to multiple each of these cells to a "multiple" as described
| above on another sheet in cells A2 through D2 respectively. (F3 to A2,
| G3 to B2, etc)
|
| This works out fine.
|
| Then I have data in cells row F4 through I4.
| When I take the formula, the the excel takes my formula and chances
| F3-I3 to F4 and I4, but changes A2 through D2 to A3 through D3. (F4 to
| A3, G4 to B3)
|
| I would like the row to change for my data, but the multiple reference
| in the formula to remain.
|
| Can anyone help this new kid on excel?
|
| Thanks.
|

Learning Excel
 

Jim,

Thank you very much. It works! I'm going to next work on building tab
menus for each of the players with a prompt asking for their daily
statistics-line which with then parse them into the various
fields/cells.

Could you recommend a book that you refer to often during your initial
studies of Excel? Also, a recommendation of visual basic books? I've
been learning what I can online, but that's assuming I know where to
look.

Learning Excel
 

with a prompt asking for their daily statistics-line which with then parse
them into the various fields/cells.

You mean like using InputBox and then putting the answer in a cell? To each
his own but I don't really understand that. The Excel grid is itself a
great input screen that everyone knows how to use. Why complicate it?

The books I bought when first learning Excel were for Excel 4, so not much
use to you<g.

Search out the name John Walkenbach for great Excel programming books. But
you'll learning the most from "doing" and asking questions here after you
wrestle with a problem for a while.


--
Jim
"georgeous" wrote in message
oups.com...
| Jim,
|
| Thank you very much. It works! I'm going to next work on building tab
| menus for each of the players with a prompt asking for their daily
| statistics-line which with then parse them into the various
| fields/cells.
|
| Could you recommend a book that you refer to often during your initial
| studies of Excel? Also, a recommendation of visual basic books? I've
| been learning what I can online, but that's assuming I know where to
| look.
|