I am trying to multiply a range of cells by a cell reference. The cells currently have hard coded values in them. I know with past special you can multiply a range of cells by a copied #. I want a similar function to that just instead of a copied cell its a cell reference. No VBA.
Thanks,
Hi jcooper and welcome to the forum,
See if the attached is what you are looking for.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
eg. if you have a list of numbers from A1 to A5 and the cell reference D1 , refer to the below formula apply in A1 and drag down.
The reference should be absolute $D$1 .
=A1*$D$1 ......
=A5*$D$1
If this helped and you wish to say thanks, then Please click on the Star* icon below this post.
Not quite what I am looking for. I have a column with hard coded values and would like to multiply those values by the same exchange rate (cell reference). If I apply formula as "Bhuvi" said the hard coded values change to the first cells value.
Hi,
Because you said no VBA, I don't think you can do this in the same cells. It sounds like you already know how to do this problem using the copy function.
What exactly are you looking for?
In Column A:
A1=1.5
A3=2
A4=4
A5=5
I would like to know if there is a quick way to multiply all 3 of the values in column A by the cell A1. (A3=2*A1; A4=4*A1; A5=5*A1). If I copy the formula down the cells will all contain the first hard coded value.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks