# Excel - IF Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

I need to figure a percentage of contribution of the grand total on multiple rows. Grand total is in a fixed location. I know there is a way to have the calculation done on cells going down the page (perhaps using the \$ sign). Tried to use \$B2/B18*100, but it only works on the first instance. If you could just tell me the name of this feature, I could look it up myself. Thanks
Solved by T. L. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 05/07/2018 - 04:04
Hi
User 05/07/2018 - 04:04
hello
Excelchat Expert 05/07/2018 - 04:04
Excelchat Expert 05/07/2018 - 04:05
I can see the problem.
Excelchat Expert 05/07/2018 - 04:05
You have to add "\$" to both row and column.
Excelchat Expert 05/07/2018 - 04:05
\$B2/B18*100
Excelchat Expert 05/07/2018 - 04:05
In this what is the total row? 2 or 18?
User 05/07/2018 - 04:06
18
Excelchat Expert 05/07/2018 - 04:06
Ok. in that case, you have fix B18 as follows.
Excelchat Expert 05/07/2018 - 04:06
=B2/B\$18*100
User 05/07/2018 - 04:06
oops, should be B18
Excelchat Expert 05/07/2018 - 04:07
Yes. It is the one fixed for all.
Excelchat Expert 05/07/2018 - 04:07
So, you have fix for row 18.
Excelchat Expert 05/07/2018 - 04:07
B is not requird to be fixed. As, the same column you are using for the calculations.
User 05/07/2018 - 04:09
so, what is the name of this functionality?
Excelchat Expert 05/07/2018 - 04:09
Sorry, i did not get?
User 05/07/2018 - 04:10
"fixed" is the name of the functionality?
Excelchat Expert 05/07/2018 - 04:10
It is fixed either row or column and is called "Absolute reference"
User 05/07/2018 - 04:10
Thanks, that will fulfill my question. goodby
Excelchat Expert 05/07/2018 - 04:11
Thank you.
Excelchat Expert 05/07/2018 - 04:11
Have a great day ahead.
Excelchat Expert 05/07/2018 - 04:11
Please visit Got It Pro.
Excelchat Expert 05/07/2018 - 04:13
Please leave a great feedback after ending the session.

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.

Get instant expert help with Excel and Google Sheets

#### Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

## Click here to get your free Excelchat help session

Trusted by people who work at