The IF function is a built-in function in Excel that is categorized as a Logical Function. This page will show the simple formula to check if the cell value is greater than the given criteria and take some action based on the result. Let’s get into this article!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel
General Formula:
- You can use the below formula to take one action when a cell is greater than a certain value.
=IF(A1>X,”Yes”,”No”)
Syntax Explanations:
- IF – The Excel IF Function will help to return one value for a TRUE result, and another for a FALSE result.
- A1 – It represents the input value from your worksheet.
- Comma symbol (,) – It is a separator that helps to separate a list of values.
- Parenthesis () – The main purpose of this symbol is to group the elements.
Example:
Refer to the below example.
- Here, we will give the input values in Column B and Column D.
- Now we need to find the result of the students based on their marks.
- So, apply the above-given formula to the formula bar section then press the “Enter” key.
- Finally, the result will be shown in the selected cell as per the below image.
Wind-Up:
In this way, we have checked the values from the cells based on certain criteria in Excel. If you feel this article is useful to you, then leave feedback in the below comment section. Thank you for Reading!! To learn more Geek Excel *and Excel Formulas *!!
Top comments (0)