# Excel - IF Function Problem - Expert Solution

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

how do I do the same formula for different cells, but i want a different cells value in each of the formulas. For example, if i was trying to find the percentage grade of each student in a class of 300.
Solved by I. W. in 14 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
User 14/09/2017 - 08:27
I believe thats it
Excelchat Expert 14/09/2017 - 08:28
Okay, great.
Excelchat Expert 14/09/2017 - 08:28
Can you explain what you are looking for in more detail.
User 14/09/2017 - 08:28
I can type out an example in the excel sheet if you would like
Excelchat Expert 14/09/2017 - 08:28
That would be perfect! Thank you.
User 14/09/2017 - 08:29
say this is five students
User 14/09/2017 - 08:29
i want to take the percentage of each students grade and post it beside it
User 14/09/2017 - 08:29
But i have over 300 students so i do not want to do it one at a time
Excelchat Expert 14/09/2017 - 08:29
Okay, This is simple for you.
User 14/09/2017 - 08:29
what formula would i use if i wanted to do them all at one time
Excelchat Expert 14/09/2017 - 08:29
Entering Explanation phase.
Excelchat Expert 14/09/2017 - 08:30
We will create an absolute reference to E1. Then copy a simple percentage formula down.
Excelchat Expert 14/09/2017 - 08:30
=B2/\$E\$1
Excelchat Expert 14/09/2017 - 08:31
The "\$" locks the cell
Excelchat Expert 14/09/2017 - 08:31
So \$E locks column E
Excelchat Expert 14/09/2017 - 08:31
and \$1 locks row 1.
Excelchat Expert 14/09/2017 - 08:31
So \$E\$1 locks cell E1.
Excelchat Expert 14/09/2017 - 08:32
Entering Discussion Phase
Excelchat Expert 14/09/2017 - 08:32
Let me know if you have any questions about the solution.
User 14/09/2017 - 08:32
After B2 would i just drag down through the column
Excelchat Expert 14/09/2017 - 08:32
Yes.
Excelchat Expert 14/09/2017 - 08:32
I have a quicker way though.
Excelchat Expert 14/09/2017 - 08:32
Click in C2 and copy.
Excelchat Expert 14/09/2017 - 08:33
then go to C3 Click and then press cntrl+shft+down arrow and select the entire sheet. Then paste.
Excelchat Expert 14/09/2017 - 08:34
Select the entire column down from C3*
User 14/09/2017 - 08:34
Perfect. My boss asked me to create a LOOKUP table so i may be coming back for more help because I am relatively new to excel.
User 14/09/2017 - 08:34
VLOOKUP*
Excelchat Expert 14/09/2017 - 08:34
We can help with that as well.
Excelchat Expert 14/09/2017 - 08:34
Have you heard of the new subscription version of Excel? You can keep using your existing computer/laptop and get latest features automatically like online file sharing, and even a browser version of Excel that work with your files. I like it.
Excelchat Expert 14/09/2017 - 08:34
You should try it. It doesn’t cost much. It’s called Office 365 Business.
User 14/09/2017 - 08:35
If i uploaded a file could you help me real quick?
Excelchat Expert 14/09/2017 - 08:36
I'm sorry, I'd love to help, but it is unfortunately against company policy and I could be disciplined if I breached contract.
User 14/09/2017 - 08:36
Understandable. Could i just join another session and receive help from it?
Excelchat Expert 14/09/2017 - 08:37
Yes.
User 14/09/2017 - 08:37
It may be against company policy again, but could i specifically request you for help?
Excelchat Expert 14/09/2017 - 08:38
Yes, you can, but another expert may still claim the question.
User 14/09/2017 - 08:38
Oh okay. Thank you for your help
Excelchat Expert 14/09/2017 - 08:38
You're very welcome. Just specify that'd you want to work with the same expert as before.
User 14/09/2017 - 08:39
Will do. If i do not have an account registered they will still be able to tell who i worked with before because of my IP address right?
Excelchat Expert 14/09/2017 - 08:40
The other experts don't see that information. We all work remotely and compete for sessions.
Excelchat Expert 14/09/2017 - 08:40
Some may avoid claiming because of your mention of previous expert though
User 14/09/2017 - 08:41
Well a question will appear at exactly X:45. which is in 4 minutes and it will have a question about a VLOOKUP table. If you see the question thats me haha
Excelchat Expert 14/09/2017 - 08:42
okay, i'll keep an eye out thank you.
Excelchat Expert 14/09/2017 - 08:42
:)

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.