HDTutorial
EN
How To Compute School Grades, Percentage, Average in MS Excel

Playback starts YouTube’s embedded player (privacy-enhanced mode).

How To Compute School Grades, Percentage, Average in MS Excel

237 views October 16, 2020 9:05

Watch on YouTube
ChannelSumra tech

Description from the creator

In this tutorial we will see how you can represent grade,%age in marksheet using Nested IF Function in Excel.
Following is the syntax of Nested IF statement.
IF(cond,"TRUE",if(cond,"TRUE",if(cond,"TRUE","FALSE"....)))
This clip will help you to
1. Find total of students score by using "SUM"
2. Calculate the grade by using "IF"
3. Count how many student got any grade by using " COUNTIF"
4. Sorting the score
I hope this video will help you.
Thank you for watching.

=IF(logical_test, value_if_true, value_if_false)

[email protected]

About this tutorial

Sumra tech published this 9:05 video tutorial on October 16, 2020. It has been watched 237 times on YouTube.

Channel
Sumra tech
Duration
9:05
Published
October 16, 2020
Views
237
Likes
26

Share

This tutorial in other languages