If in Excel have verity of forms and applications. We can use IF formula to check the Boolean condition. We can return some value if the condition is true and some other value if not true or false. Let us see the in-depth details about If in Excel.
If Formula in Excel
We can use the If formula in Excel to check if a condition is meeting certain scenario. For example, we can check if the given value is equals to an integer. We can use If formula to compare two strings. We can return the values based on the Boolean result of If formula in Excel. The following example check if the given value is greater than 10 or not. And return the message based on the result.
=If(25>10,"Given Value is bigger than 10","Given Values is Not Bigger Than 10")
If Formula to check Cell Values
We can check the cell value using If formula and perform the calculations based on the result. Here is a simple example in Cell B1 to check if a cell (A1) is less than or equals to 1000 or not. And add 500 if the values is less than 1000.
If formula checks the condition (A1<1000) and add 500 if the cell value is less than 1000, it will return the same value if the condition fails.
If Formula to check all values in a Column
We can check the values in a column and perform certain calculation based on the result. Let us see an example to check if any value in column B is equals to zero and flag the respective cell in Column C.
You can put this formula in C1 and fill-down upto rows of B1.