Excel help...

[Al Neri]

I have a spread sheet like such

______________
| 0 | 1 | 2 | 3 | 4 | 5 |
|....|....|....|....|....|......|
|....|....|....|....|.50|.....|
|....|A..|....|....|....|......|
|....|B..|....|....|....|......|
|....|C..|....|....|....|......|
|....|D..|....|....|....|......|
|....|etc|....|....|....|......|

I want to be able to scroll down and have a,b,c,d equal to 50 * A1 (which is 0), 50 * A2 (which is 1*50),etc.

how can I go about doing that?

 

[theknight571]

I'm not 100% sure I understand what you're looking for...

Are you looking for the results to look like this:

| 0 | 1 | 2 | 3 | 4 | 5 |
|....|....|....|....|....|......|
|....|....|....|....|.50|.....|
|....|0..|....|....|....|......|
|....|50.|....|....|....|......|
|....|100|....|....|....|......|
|....|150|....|....|....|......|
|....|etc|....|....|....|......|

??

Or can you explain a little more what you're trying to do.

- TK

 

[Kyteland]

In the column to the left of a,b,c,d you can use the transpose() function to make a copy of the row across the top.

Or in row 2 you can make the function (=50*A1) and fill right. Highlight the resulting row and copy. Go to the column you want. Right click and select 'paste special'. There is a checkbox on the bottom called 'transpose' that will paste everything rotated in to a column.

There is no easy way to use the fill down option to do this.

 

[Al Neri]

Originally posted by: theknight571
I'm not 100% sure I understand what you're looking for...

Are you looking for the results to look like this:

| 0 | 1 | 2 | 3 | 4 | 5 |
|....|....|....|....|....|......|
|....|....|....|....|.50|.....|
|....|0..|....|....|....|......|
|....|50.|....|....|....|......|
|....|100|....|....|....|......|
|....|150|....|....|....|......|
|....|etc|....|....|....|......|

??

Or can you explain a little more what you're trying to do.

- TK

yes i am

 

[theknight571]

One option: Cell A is set to 0, Cell B = Cell A + Value (50 in your example), Cell C = Cell B + Value ..., you chould copy/paste the equation as far down as needed. If you use reference to the cell holding the Value, when you change that cell, all cells (A, B, C,...) would change automatically.

|...|.A..|.......B......|.C.|.D.|.E.|
|.1.|....|...............|....|....|.50|
|.2.|....|.......0.......|....|....|....|
|.3.|....|(B2+$E$1)|....|....|....|
|.4.|....|(B3+$E$1)|....|....|....|
|.5.|....|(B4+$E$1)|....|....|....|
|.6.|....|(B5+$E$1)|....|....|....|


Another Option: Number the rows and use the number to mutiply the Value.

|...|.A..|.......B......|.C.|.D.|.E.|
|.1.|....|...............|....|....|.50|
|.2.|.0.|...............|....|....|....|
|.3.|.1.|(A3*$E$1)|....|....|....|
|.4.|.2.|(A4*$E$1)|....|....|....|
|.5.|.3.|(A5*$E$1)|....|....|....|
|.6.|.4.|(A6*$E$1)|....|....|....|



The $ in the Cell references prevent the reference from changing when pasted to another cell.... so no matter where you paste the formula the reference will remain $E$1 while the other reference will change, relative to the original cell.

Hope this helps.