Excel gurus, need help

[FerrariEnzo]

I want to know if its possible to make a formula with a base number...
Lets say 140 is the base number I will be using for A1-F1.
For each cell I enter a different number, each either adds, multiply, etc whenever I enter a number....

i.e.
A1 - 140*43

So I just enter 43 into A1 and it will multiply for me when I hit enter or click a different cell...

[gars]

You can enter this formula in A2

=A1*140

then put your cursor on the bottom right hand corner of A2 (while it's selected) until the cursor turns to a + sign, then drag it down to F2. It should automatically populate the cells with =B2*140, =C2*140, etc.

When you type 43 into A1, A2 should automatically read 6020.


If you want to the base number to change easily - instead of putting in 140, you can reference another cell (like A3 or something), so the formula would be

=A1*$A$3

The $ sign makes it an absolute value, so if you were to auto populate the other cells, the reference to A3 won't change.


Not sure if this makes any sense.

[tiger_handheld]

A1 = 43 x 140
A2 = 44 x 140
A3 = 45 x 140

If you want 140 to be the constant, type in 140 into D1 and type the following into:

A1 = 43* $D$1 [ you can do this or when excel selects D1, click on it and press F4, it'll auto put the $ signs]
A2 = 43* $D$1
etc

If you want to change 140 into 145, change in D1.

[FerrariEnzo]

thanks.. I will try it in a bit...

[FerrariEnzo]

Originally Posted by gars

You can enter this formula in A2

=A1*140

then put your cursor on the bottom right hand corner of A2 (while it's selected) until the cursor turns to a + sign, then drag it down to F2. It should automatically populate the cells with =B2*140, =C2*140, etc.

When you type 43 into A1, A2 should automatically read 6020.


If you want to the base number to change easily - instead of putting in 140, you can reference another cell (like A3 or something), so the formula would be

=A1*$A$3

The $ sign makes it an absolute value, so if you were to auto populate the other cells, the reference to A3 won't change.


Not sure if this makes any sense.

Almost what I had in mind but is it possible to put the formula into A1, B2, etc
Then just type in any numbers into A1 and have that cell come up with the final answer?

[Alby]

so you want A1, B2, etc to contain a formula in the cell, AND you want to input the number into the SAME cell and for an answer to show up? im not sure if you are able to do that.

[gars]

Yeah, what Alby said - it won't work. If there's a formula in the cell, if you put something else on top of it - the formula will be overwritten.

I'm not sure what your workflow is, You can hide the first column after you've inputted all the data... Not sure if that's what you're looking for.

[FerrariEnzo]

I see... I didnt think it was possible but im not all the familiar with excel so I thought Id ask some experts...

Thanks for the help

[JesseBlue]

Use separate cells for constants , formulas and variables...
Then play with the formatting, color and in no time youll end up an excel guru...

[FerrariEnzo]

how would I keep a line from printing which contains the number I input for the formula to calculate.

[Alby]

move it out of the printing area may be the easiest?

[FerrariEnzo]

like a new page?

[Alby]

you can keep it on the same page. the printing area is usually bordered with dotted lines which are visible when you hit it. move it out of the area and when you print just make sure its printing that area that you want.