Question description:
This user has given permission to use the problem statement for this
blog.
in row 1, I have cells that are set up as percentages for the columns.
I want to times the number in column A by the percentages in row 1, for the rest of the row by starting the formula =B2*A2 then dragging along the rest of the row.
What happens is the formula automatically changes the B2 to the next column as it drags.
How do it get it so that when I drag the formula stays with *B2, but will change the other part of the formula to the correlating percentage?
Solved by B. J. in 9 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
14/06/2018 - 01:55
Hi…Welcome to Got It Pro
User
14/06/2018 - 01:55
hi
User
14/06/2018 - 01:56
It's a bit hard to explain when I cant speak the language.
Excelchat Expert
14/06/2018 - 01:56
Can we do a quick simulation in this preview sheet?
User
14/06/2018 - 01:56
yes sure
User
14/06/2018 - 01:56
would you like me to go?
Excelchat Expert
14/06/2018 - 01:56
sure
User
14/06/2018 - 01:57
so I have set up cost centres in columns, and cost centres are all paying for a percentage of an admin expense.
User
14/06/2018 - 01:58
okay, so then i put an expense in the budget
User
14/06/2018 - 01:59
then I want the cost centres to show the expense in their columsn
User
14/06/2018 - 02:00
yep. please explain
Excelchat Expert
14/06/2018 - 02:00
i have just done the formula
Excelchat Expert
14/06/2018 - 02:00
I am using absolute and relative cell references to lock the cells when required.
User
14/06/2018 - 02:01
ah yes, I do not know about absolute and relative cells
Excelchat Expert
14/06/2018 - 02:01
Say cell C4 =$A4*C$2
User
14/06/2018 - 02:02
yep. so the dollar signs mean something?
Excelchat Expert
14/06/2018 - 02:02
$A4 means column A is static when you drag it to right, while row number can vary when you pull down
Excelchat Expert
14/06/2018 - 02:02
Yes, dollar sign means absolute reference
Excelchat Expert
14/06/2018 - 02:02
and no dollar mean relative reference
User
14/06/2018 - 02:02
I see, so whenever you put the $, the reference cell wont change?
Excelchat Expert
14/06/2018 - 02:02
Similarly, C$2 mean column can vary but rows remains static
Excelchat Expert
14/06/2018 - 02:03
Yep...that's right
User
14/06/2018 - 02:03
I see. Very helpful.
Excelchat Expert
14/06/2018 - 02:03
Is there anything else I can help you with this query?
User
14/06/2018 - 02:03
no, thats a new wonder openned up for me.
User
14/06/2018 - 02:03
Cheers
Excelchat Expert
14/06/2018 - 02:03
Yes, it makes excel a lot friendlier
Excelchat Expert
14/06/2018 - 02:04
Please do give me a good feedback for my service.
Excelchat Expert
14/06/2018 - 02:04
Thanks for your time. Please do come back for any new question. Have a great day ahead!
User
14/06/2018 - 02:04
Thanks. I will do!
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.