When using Excel, sometimes we want to check if a number meets a certain condition and then decide what to show based on the result. That’s exactly what the IF function does.
In this example, we’ll use the function:
Excel checks if the value in cell E5 is less than 50.
If yes (TRUE), the result is 1.
If no (FALSE), the result is 0.
It’s a great way to quickly mark results like pass/fail, yes/no, or present/absent based on simple conditions.
Example Use Case:
Let’s say E5 contains a test score:
If E5 = 45 → Excel returns 1
If E5 = 78 → Excel returns 0
So, the IF function helps you make decisions automatically in your sheet.
This is very useful for marking student grades, attendance, or sales targets.
Image Suggestion:
Insert an image showing:
A sample Excel sheet with numbers in E5
The formula
=IF(E5<50, 1, 0)typed in another cell (e.g., F5)The result displayed as 1 or 0
In Excel, you can use the IF function to check whether a student (or any value) passes or fails based on their marks. Here’s a very common example:
Excel checks if the value in cell E5 is greater than or equal to 50.
If yes (TRUE), it will display “Pass”.
If no (FALSE), it will display “Fail”.
Important Tip:
Always put text values in quotes inside a formula. So "Pass" and "Fail" must be enclosed in quotation marks.
Image Suggestion:
Show an Excel screenshot where:
E5 contains a value (like 62 or 47)
Formula
=IF(E5>=50, "Pass", "Fail")is used in cell F5F5 displays “Pass” or “Fail” based on E5
Leave a Reply