How to Apply Percentage Formula in Excel for Marksheet (7 Applications)

Method 1 – Fundamental Percentage Formula in Excel for a Marksheet

If we want to determine what percentage of A is B we will use the following formula.

We have marks for 3 subjects for five students and their total obtained marks. Here, the total mark for 3 subjects is 300. We will calculate what percentage of total marks each student gets.

Steps:

Select cell G5.
Insert the following formula in that cell:

=(F5/300)*100

Press Enter.

Select cell G5 again.
Move the mouse cursor to the bottom right corner of the selected cell so that it turns into a plus (+) sign like the following image.
Click on the plus(+) sign and drag the Fill Handle down to cell C9 to copy the formula of cell G5 in other cells. You can also double-click on the plus (+) sign to get the same result.

This copies the formula of cell G5 to the other cells.

Method 2 – Apply a Percentage Formula from Excel Ribbon

We will calculate the percentage of our previous dataset again.

Steps:

Select cell G5.
Insert the following formula in that cell:

=(F5/300)

We have not multiplied the value by 100 here like the previous example.

Press Enter. This returns the value in decimals.

Go to the Home tab.
Select the option Percent Style (%) or press Ctrl + Shift + % after selecting the cell G5.

This converts the decimal value into a percentage.

Drag the Fill Handle tool from C5 to cell G9.

This returns all the values in percentages.

Method 3 – Extract a Particular Value Using Percentage Formula in Excel

Case 3.1 – Evaluate Individual Marks by Total and Percentage

In the following dataset, we have the total marks and percentages gained by all students. We will calculate the Obtained Marks for each student.

Steps:

Select cell E5.
Insert the following formula in that cell:

=D5*C5

Hit Enter.

Drag the Fill Handle tool to cell E9.

This returns the marks for all students in cells (G5:G9).

Case 3.2 – Use Individual Marks and a Percentage to Evaluate Total Marks

We have the value of Obtained Marks and Percentage in our following dataset. We will calculate the total marks by using these two values.

Steps:

Select cell E5.
Insert the following formula in that cell:

=C5/D5

Press Enter.

Drag the Fill Handle tool to cell E9.

This returns the value of total marks in cells (E5:E9).

Method 4 – Use Percentage Formulas in Excel to Modify Existing Marks by a Percentage

Case 4.1 – Increase Marks by a Percentage

We have the following dataset, which contains the obtained marks for six students in the subject of English. We will increase the marks of each student by different percentages.

Steps:

Select cell E5.
Insert the following formula in that cell:

=C5*(1+D5)

Hit Enter. We get the increased value in cell E5.

Drag the Fill Handle tool to cell E9.

This fills in the cells (E5:E9).

Case 4.2 – Decrease Marks by a Percentage

We will decrease the value of obtained marks by a specific percentage.

Steps:

Select cell E5.
Insert the following formula in that cell:

=C5*(1-D5)

Hit Enter.

Drag the Fill Handle tool to cell E9.

We can see the decreased marks for all students in cells (E5:E9).

Method 5 – Modify the Entire Column of a Marksheet With a Percentage Formula in Excel

In the following dataset, we have a mark sheet of six students containing their marks in English. We’ll increase and decrease the marks of all students by 10%.

Steps:

Copy the same value of marks in the columns “Increased 10%” and “Decreased 10%”.

Increasing by 10% means multiplying by 1.1 and decreasing by 10% means a multiplier of 0.9.
Select cell D11.
Click on the Copy from ribbon or press Ctrl + C.

Select the cells (D5:D9) and go to Paste Special.

A new dialogue box will appear.
Check the option “Multiply” from that box.
Press OK.

This increases all the values of cells (D5:D9) by 10%.

Follow the same process with the cell D12 and the range (E5:E9).

Method 6 – Create a Dynamic Marksheet in Excel

We will create a dynamic mark sheet by using the percentage formula.

Steps:

Select cell G5 and insert the following formula:

=IF(F5<40%,"F",IF(F5<60%,"C",IF(F5<80%,"B","A")))

Hit Enter.

Drag the Fill Handle tool to cell G9.

We can see the grades for all students in the column “Grade”.

If we change the marks in cell E7 from 144 to 160, the grade will automatically change from B to A.

The conditions that we have used in the formula:

If the percentage is > 80%, it will return A, if the percentage is < 80%, it will return B, if the percentage is < 60%, it will return C, and if the percentage is < 40%, it will return F.