Microsoft Excel Problem

[pjphilli (Peter)]

Hi
Although I am reasonably computer literate I have problems with Excel when it comes to using formulas and I find that Help is not very helpful.
Could someone tell me how by using a single formula I can multiply separately each of the contents of all the rows of a column (B) by a single digit for presentation separately in the adjacent rows of the next column (C)?
Hope this makes sense!

Cheers Peter

[Merlin66 (Ken)]

In the first cell of column C enter " = B1*5" where B1 is the first cell in the B column and 5 is the fixed number..
Copy this formula down the C column....

[iborg (Philip)]

Slight but, type into the cell what is inside the quotes, not the quotes themselves.

I have had someone include the quotes.

Have fun

[DavidLJ (David)]

As a variation on Ken's suggestion : Enter your multiplier value (say 5) into a cell (say D1). Then in the first cell of column C enter “=B1*D$1” - again omitting the double quotes. Then copy that formula down into all of the other relevant cells in column C. By using this approach you can simply change the value in cell D1 to any number that you like and your change will automatically affect all of the calculations in column C. Note that by using the dollar sign ($) in the formula the row number of the cell in which the multiplier value is entered (in this case 1) is made absolute with the result that the copied formulae for the first three rows in column C will read “=B1*D$1”, “=B2*D$1” and “=B3*D$1”.

[pjphilli (Peter)]

Thanks all for your help.

A further question. I can work this by putting the formula into the lower rows of C by typing it in each time. Since I have a lot of rows involved is there some way I can copy the formula into all the rows of C
(whilst automatically changing the number indicated of row B) in one action?
(Tried various things which don't work).

Cheers Peter

[Merlin66 (Ken)]

Peter,
enter the formula into the top cell on column c.
Then right click on the cell, copy...
go to the next cell in the C column and press the left mouse button and while pressed, highlight the column to the bottom, then press the right mouse button and select paste.
This should copy the formula to each of the cells in the C column.

[redbeard (Damien)]

Originally Posted by pjphilli

Thanks all for your help.

A further question. I can work this by putting the formula into the lower rows of C by typing it in each time. Since I have a lot of rows involved is there some way I can copy the formula into all the rows of C
(whilst automatically changing the number indicated of row B) in one action?
(Tried various things which don't work).

Cheers Peter

An easy way for this is to select the first cell with the formula in it and you will notice when you move the mouse to the bottom right hand corner of that cell, there is a little black square and the mouse cursor will change to a plus symbol. Simply click and drag this down to all cells with the mouse. The formula will auto copy and reflect the correct cell calculations.

Cheers

[CJ (Chris)]

I'm not sure if this will help but it's worth knowing anyway.
If you highlight a cell, then put you cursor near the bottom right corner of that cell, you should see a small cross appear. Dragging this cross down the column, or across the row, fills those cells with various values which reflect what the first cell contains. It works with formulas, ascending or descending values, days of the week etc. It might do what you require. Using crtl at the same time changes the behaviour of the resulting cell contents.
Have a fiddle and see if it does what you want.
Cheers

Edit, Damien posted his reply while I was typing!

[CJ (Chris)]

You can also use that technique to create a sequence of incremental jumps.
Say A1 = 5 and B1 = 10, highlighting both cells and then dragging the cross will result in C1, D1 etc filling in with 15, 20 and so on.
Cheers

[pjphilli (Peter)]

Thanks All again - Your suggestions worked perfectly and I have also saved them for further possible use. Easy when you know how!
Cheers Peter