Multiplying All Cells in Column by 0.30

Trying to setup a way that all items in a column will be multiplied by 0.30 and the result sent to another column. I can do this with each individual cell or with every cell all at once.

I want it to change as I change information (so a formula) but apply to the entire column so paste special wasn't working for a permanent solution.

I assume there is some way to do it with a formula that substitutes the A1 with AX where X is whatever row I am currently in, or something of that nature.

I haven't used excel in a few years so any help is appreciated.

Maybe this helps explain it better:

Column 1

11
12
13
14
15
16

Those are all numbers that might be contained in column 1. I want to multiply all of those numbers by 0.3 so that column 2 contains the results like this.

11x0.3
12x0.3
13x0.3
et cetera

However the current problem I have is I am having to multiply every cell individually. If I did this:

17 (a new cell) I would want column 2 to automatically multiply it by 0.3 without me having to add an additional formula per cell.]

Hope that helps.

Thanks

I did =Product(B2,0.3) for my formula.
I pasted and changed the B3 and B4 and then it realized what I was doing and fixed the entire thing.

I tried to replicate this afterwards and it didn't catch on. Instead, I had to do each B3 and B4 individually (which completely eliminates the purpose of what I was doing).

Any idea what I am doing wrong?

If you drag the formula down (placing the cursor in the righthand bottom corner of the cell and click and drag with the mouse), the cell ID's should automatically update. Alternately, you can copy that cell, highlight all the cells below it that you want to paste into and CNTRL V to paste it into all of them simultaneously (again, Excel will automatically update the formulas). Is this working?

ChemistB

Copy or manually type this formula to add the numbers automatically
Note: My totals are numbers.
In this case, you must change the row and/or column where the totals are calculated, (Where the formula to add the numbers is)
In my example its F2.
So,
=(F2)*(0.3)
Every time the total changes, this formula will change as well.
Then Select Format cells and choose currency.
Now it will show in $$ and the dollar amount will change when the total is updated.
This is automatic. every time the total formula changes, the formula for the 0.30 will change as well.
Good luck!