Techyv.com

Calculation MS Excel Percentage Formula Automatically

Asked By Manbro Star 0 points N/A Posted on - 01/06/2018

Hello everyone, I have to create a report of my class student in an excel sheet in which I have to sort the list of the student according to their percentage. Is there any MS Excel Percentage Formula which could make my work easier?

• Status: Open
• Question Views: 161
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Software Others
• Question Tags: MS excel

Answered By Michael C Clack 0 points N/A #307532

Calculation MS Excel Percentage Formula Automatically

Excel is a Microsoft office package which works on File System and also uses for database purpose.

It supports many mathematical operations such as arithmetic operations and Percentage etc.

For example, if we are wishing to calculate 30% of 500.

Then you need to write 30% multiply on 500.

So finally you have to type in any Excel cell:

=30%*500.

Finally, the result will be 150.

About Michael C Clack

Questions
9

Answers
1

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 01/06/2018
• Question Category: Software Others

Answered By Sharath Reddy 574765 points N/A #309737

Calculation MS Excel Percentage Formula Automatically

That would be easy. You only need to sort the students by percentage. You just need to enter the list normally like the name of the students and their respective percentage and when you are finished, you need to select all the data needed to be sorted. Here is an example:

Once the list is prepared, highlight the data to be sorted.

Next, in “Home” tab, in the “Editing” ribbon, click “Sort & Filter” then select “Custom Sort”.

In the Sort window, configure the settings. Under “Column”, select the column where the percentage is listed. In the example, the percentage is listed under column K so I select “Column K”. Under “Order”, select either “Smallest to Largest” or “Largest to Smallest” to set the sort order and then click “OK”.

And that’s it. The data should now be sorted according to their percentage.

About Sharath Reddy

Questions
2

Answers
11674

Best Answers
2289

• Vote Up 0 Vote Down

• Posted on - 04/09/2018
• Question Category: Software Others