Excel - COLUMN Function Problem - Expert Solution

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

We voted for personnel now I am attempting to rank them with different percentages. Column B is worth 40%, Column C is worth 50%, Column D is worth 10% what formula do I use for each column and for the total column in E?
Solved by S. L. in 27 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 31/01/2018 - 04:48
hi
User 31/01/2018 - 04:48
hello
Excelchat Expert 31/01/2018 - 04:48
can you share me the sheet?
User 31/01/2018 - 04:48
how di I do that
Excelchat Expert 31/01/2018 - 04:49
Excelchat Expert 31/01/2018 - 04:49
like the screen shot
User 31/01/2018 - 04:51
I do I get it off my onedrive
Excelchat Expert 31/01/2018 - 04:52
ok
User 31/01/2018 - 04:54
im attempting to share from my onedrive
Excelchat Expert 31/01/2018 - 04:54
ok
Excelchat Expert 31/01/2018 - 04:54
i can see the shared sheet
User 31/01/2018 - 04:55
I started typing in this one can we use it
User 31/01/2018 - 04:55
basically as I asked, I am looking to make column B 40% column and so on of what is titled.
Excelchat Expert 31/01/2018 - 04:56
yes
User 31/01/2018 - 04:56
In the end i need to tal these votse, its just that the votes are weighted
Excelchat Expert 31/01/2018 - 04:57
what is the number sugest in cell B2:D6 ?
User 31/01/2018 - 04:58
these number ma be a decimal as well.
Excelchat Expert 31/01/2018 - 04:58
is it score out of 5 ?
User 31/01/2018 - 04:59
hypothetically in the original document it well be out of 22, basically it is an employee ranking system between 1-22
Excelchat Expert 31/01/2018 - 05:00
can you send me the screen shot of the origional sheet?
User 31/01/2018 - 05:01
i could probably type the original sheet faster.
Excelchat Expert 31/01/2018 - 05:02
ok can i take this number out of 5 and make the formula?
User 31/01/2018 - 05:02
cool
Excelchat Expert 31/01/2018 - 05:04
hello can you see the formula?
Excelchat Expert 31/01/2018 - 05:04
in column E ?
User 31/01/2018 - 05:04
ok that was awesome, so thats the formulas for column E?
Excelchat Expert 31/01/2018 - 05:04
yes
Excelchat Expert 31/01/2018 - 05:05
do you understand this formula?
Excelchat Expert 31/01/2018 - 05:05
=(B2/5*0.4)+(C2/5*0.5)+(D2/5*0.1)
User 31/01/2018 - 05:05
yes for column E, do I have to put the formula in for B, C, or D?
Excelchat Expert 31/01/2018 - 05:06
no need to put formula in B,C and D because i already mentioned in Column E
Excelchat Expert 31/01/2018 - 05:06
if you change the total score from 5 to 22 then you need to replace 5 to 22 in formula =(B2/5*0.4)+(C2/5*0.5)+(D2/5*0.1)
Excelchat Expert 31/01/2018 - 05:07
do you understand?
User 31/01/2018 - 05:08
Do I have to put this in all of column E? So do I just drag in column E down 22 rows
Excelchat Expert 31/01/2018 - 05:08
yes
Excelchat Expert 31/01/2018 - 05:08
you have to drag only
Excelchat Expert 31/01/2018 - 05:08
column E
Excelchat Expert 31/01/2018 - 05:09
you can drag and check it that the formula will automatically be inserted
User 31/01/2018 - 05:09
can you show me that again how you just drag
Excelchat Expert 31/01/2018 - 05:10
i dragged
User 31/01/2018 - 05:10
I think I got it, apologize for my lack of skills.
Excelchat Expert 31/01/2018 - 05:11
User 31/01/2018 - 05:11
yes
Excelchat Expert 31/01/2018 - 05:12
ok bye
Excelchat Expert 31/01/2018 - 05:13
hello are you there?
User 31/01/2018 - 05:14
yes should I close out
Excelchat Expert 31/01/2018 - 05:14
User 31/01/2018 - 05:14
ok one last question, How do I make column E a percentage
Excelchat Expert 31/01/2018 - 05:15
select the column and press the format as %
User 31/01/2018 - 05:15
thank you

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.