Sometimes you came across missing values or wants to highlight some absent volunteers or students in your worksheet to highlight it and present it to your authority then keep following this space to learn how to highlight it.
This can be used at times when there are a lot of data missing. To understand the same, let’s take an example:
As you can observe in the image above, we have taken an example of a bunch of students and their totaling of marks scored in every subject.
The blank refers to the student missing that exam I the above example.
Now let’s begin. The first thing that we will do is input the function of OR.
The formula requires logics.
The first logic in the data is the marks scored in the subject “301”, i.e. 72 marks (cell C4).
Then we will put an equal to sign with quotation marks having nothing in it, i.e. = “”
Through equal to, we mean we are taking out result and by the empty quotation marks, we mean that if the cell is blank then it should be informed.
Then we will select the second logic, i.e. the marks scored in subject 302, i.e. 81 marks (cell D4).
Then again, we will repeat the same thing, i.e. = “”
Then we will select our third logic. You can add as many logics as you want, it depends on your data.
As we have three subjects, so we will be working on 3 logics.
So, the third logic is the marks scored in the subject code 303, i.e. 91 marks (cell E4).
Again, we will repeat the equal to and empty quotation marks sign.
Then we will close the bracket, which makes our formula complete, i.e.
=OR(C4 = “”, D4 = “”, E4 = “”)
Then we press enter and the answer comes out as FALSE. This means that there was no missing exam in relation to roll no. 3231.
Now, to find out the answer of other roll nos. in a fast pace, we will drag the formula down which will make our work easier.
(Refer to the image above.)
Now, we will total the overall marks scored by the roll nos. by using the =SUM( Formula.
As we know that the SUM Formula requires numbers, so we will select the marks of all three subject codes and we will press enter.
Here’s the overall marks obtained by each student.
*you may ignore the warning sign, its there because the SUM is taken out of the values that are adjacent.
And there you go.
It’s easy, isn’t it?