Hello,
I was not sure which Excel Group this should be asked in, so sorry if this
is the wrong one.
If I have a column of values, how can I create a formula in each cell to be
value * an absolute cell in the worksheet. For example I have:
345
367.45
241.67
I want to have:
=345 * $x$2
=367.45 * $x$2
=241.67 * $x$2
I want the formula in the cell when I am done which would refer to the same
cell (x2) as opposed to having just a total number. And I was hoping I could
do this without hitting F2 and editing each cell manually since my actual
column is much larger.
Any suggestions, would be greatly appreciated! Thanks in advance.
Bookmarks