Latest Posts From Annyca Tabassum
In this article, you will learn the ins and outs of how to show gridlines in Excel. We will also discuss how to hide and change gridline's color, how to print ...
Annyca Tabassum
In this article, you will learn about nested formula in Excel and their application with different functions. You will get to know about the use of the most ...
In this article, you will learn about the indentation in Excel. You get to know how to indent by using ribbon, shortcut and many more methods. We will also ...
In this article, we will explore the process of extracting an Excel Table from image. The table is an important feature of Excel. Tables are used to analyze ...
Excel slicer is a vital tool that gives users easy access to data filtering and interaction. Slicers are often shown vertically, although a horizontal ...
Microsoft Excel is a powerful application that contains robust features to improve data analysis and visualization. The Excel slicer is one such feature that ...
In Excel, you may apply multiple conditions to sum values. From them, the greater than and less than condition is mostly used. You can use both conditions at a ...
Dear KRISHNA KANT,
Thank you for giving your time to read this article. You want to know the formula to calculate the ranks and denote “Fail” if a student is absent in any of the exams. Read the following section for details.
Assuming the given data is placed in columns B to G, and the student rank will be shown in column H.
In cell H5, enter the following formula:
=IF(COUNTIF(C5:F5,"Absent")>0, "Fail",RANK(G5,$G$5:$G$10,0))Drag the formula down to apply it to the rest of the cells in column H.
The overall formula checks if there are any cells with the value “Absent” in range C5:F5. If there exists, it returns “Fail“. Otherwise, it calculates the rank of the value in G5 within the range G5:G10 in ascending order.
The student’s total score and rank are displayed in column G, and column H respectively. If a student is “Absent” in any of the exams, their rank will be denoted as “Fail.”
If you have any more queries, please let us know in the comments.
Regards
Annyca Tabassum
Team ExcelDemy