If you want to make a result sheet, Excel can be really helpful. The main objective of this article is to explain how to** make result sheet **in Excel.

**Table of Contents**hide

## Download Practice Workbook

## 6 Easy Steps to Make Result Sheet in Excel

Here, I have taken the following dataset. It contains the **Student ID** and **Name**. I will **make result sheet **in Excel for these students with **6** easy steps.

### Step-01: Entering Data

In this first step, I will show you how you can enter data for your result sheet.

- Firstly, make columns for the subjects you have. Here, I made columns for
**English**,**Math**,**Physics**,**History**, and**Art**.

- Secondly, insert the obtained marks for these subjects. Here, I have inserted mine.

**Read More: ****How to Make Automatic Marksheet in Excel (with Easy Steps)**

### Step-02: Using MAX and MIN Functions

In this step, I will use **the MAX function** and **the MIN function** to find the **Highest **and **Lowest **obtained marks for each student.

- Firstly, select the cell where you want the
**Highest**marks. Here, I selected cell**I5**. - Secondly, in cell
**I5**write the following formula.

`=MAX(D5:H5)`

Here, the **MAX** function will return the **Highest **found marks in cell range **D5:H5**.

- Thirdly, press
**ENTER**to get the result.

- After that, drag the
**Fill Handle**to copy the formula.

Now, you can see that I have copied the formula to all the cells and got the **Highest** number for each student.

Here, I will find the **Lowest **number for each student.

- Firstly, select the cell where you want the
**Lowest**number. Here, I selected cell**J5**. - Secondly, in cell
**J5**write the following formula.

`=MIN(D5:H5)`

Now, the** MIN** function will return the **Lowest **found number in the range **D5:H5**.

- Thirdly, press
**ENTER**to get the result.

- After that, drag the
**Fill Handle**to copy the formula.

Here, you can see that I have copied the formula to all the cells and got the **Lowest** number for every student.

**Read More: ****How to Calculate Percentage of Marks in Excel (5 Simple Ways)**

### Step-03: Use of SUM Function to Get Total Obtained Marks

In this step, I will calculate the **Total** marks for each student in the result sheet in Excel. I will use **the SUM function** for this calculation.

- Firstly, select the cell where you want to calculate the
**Total**marks. Here, I selected cell**K5**. - Secondly, in cell
**K5**write the following formula.

`=SUM(D5:H5) `

Here, the** SUM **function will return the **summation **of the values in the cell range **D5:H5**.

- Thirdly, press
**ENTER**to get the**Total**marks.

- After that, drag the
**Fill Handle**to copy the formula. To the other cells.

Now, you can see that I have copied the formula to all the other cells and got **Total **marks for every student.

**Read More: ****How to Apply Percentage Formula in Excel for Marksheet (7 Applications)**

**Similar Readings**

**How to Calculate Letter Grades in Excel (6 Simple Ways)****Calculate Average Percentage Increase for Marks in Excel Formula****How to Calculate Grade Percentage in Excel (3 Easy Ways)**

### Step-04: Employing AVERAGE and ROUND Functions in Result Sheet

The 4th step to making a **result sheet **in Excel is to calculate the **Average** marks for each student. Here, I will use **the AVERAGE function** and **the ROUND function** for this step.

- Firstly, select the cell where you want your
**Average**marks. - Secondly, write the following formula in the selected cell.

`=ROUND(AVERAGE(D5:H5),0)`

**Formula Breakdown**

**AVERAGE(D5:H5) —->**Here, the**AVERAGE**function will return the average of the cell range**D5:H5**.**Output: 72.6**

**ROUND(AVERAGE(D5:H5),0)****—->**turns into**ROUND(72.6,0) —->**Here, the**ROUND**function will return the rounded number to the given**num_digits**which is**0**in this case.**Output: 73**

- Thirdly, press
**ENTER**to get the**Average**marks.

- After that, drag the
**Fill Handle**to copy the formula.

Now, you can see that I have copied the formula to all the cells and got the **Average** number for every student in my **result sheet** in Excel.

**Read More: ****How to Calculate Average Percentage of Marks in Excel (Top 4 Methods)**

### Step-05: Using Nested IF Function to Show Grades

Here, I will explain the 5th step of how to **make result sheet** in Excel. In this step, I will use **the Nested IF function** to show the **Grades**. For this step, I won’t need numbers in individual subjects. For this reason, I have hidden those columns. So, you will be able to get a better view.

- Firstly, select the cell where you want to show your
**Grades**. Here, I selected cell**M5**. - Secondly, in cell
**M5**write the following formula.

`=IF(J5<60,"F",IF(L5>=90,"A",IF(L5>=80,"B",IF(L5>=70,"C",IF(L5>=60,"D","F"))))) `

**Formula Breakdown**

- Here, in the
**IF**function, I selected**J5<60**as**logical_test**,**“F”**as**value_if_true**, and another**IF**function as**value_if_false**. - Then, in the second
**IF**function, I selected**L5>=90**as**logical_lest**,**“A”**as**value_if_true**, and a third**IF**function as**value_if_false**. - Next, in the third
**IF**function, I selected**L5>=80**as**logical_lest**,**“B”**as**value_if_true**, and another**IF**function as**value_if_false**. - After that, in the fourth
**IF**function, I selected**L5>=70**as**logical_lest**,**“C”**as**value_if_true**, and another**IF**function as**value_if_false**. - Finally, in the last
**IF**function, I selected**L5>=60**as**logical_lest**,**“D”**as**value_if_true**, and**“F”**as**value_if_false**.

- Thirdly, press
**ENTER**.

- After that, drag the
**Fill Handle**to copy the formula.

Now, you can see that I have copied the formula to the other cells and the **Grades** are showing.

**Read More: ****How to Compute Grades in Excel (3 Suitable Ways)**

### Step-06: Applying RANK.EQ Function in Result Sheet

In this step, I will show the ranks in the **result sheet **in Excel. I will use **the RANK.EQ function** to show the ranks.

- Firstly, select the cell where you want the
**Rank**. Here, I selected cell**N5**. - Secondly, in cell
**N5**write the following formula.

`=RANK.EQ(K5,$K$5:$K$14,0)`

Here, in the **RANK.EQ** function I selected **K5** as **number**, range **K5:K14 **as **ref**, and **0 **as **order **which is the **descending order**.

- Thirdly, press
**ENTER**.

- After that, drag the
**Fill Handle**to copy the formula.

Finally, you can see I have copied the formula to all the cells and thus ranked the students.

Now, I will unhide the hidden columns so that you can see my final **result sheet** in Excel in the following image.

**Read More: ****How to Make a Grade Calculator in Excel (2 Suitable Ways)**

## Practice Section

Here, I have provided a practice sheet for you to practice how to **make result sheet** in Excel.

## Conclusion

In this article, I tried to explain how to **make result sheet **in Excel with **6** easy steps. I hope this article was helpful for you. Lastly, if you have any questions let me know in the comment section below.