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
you can add by attachment
[Uploaded an Excel file]
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
please help me by give rating 5
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
yes please close the session
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.
