Formula If Function Excel. Excel if function syntax and usage the if function is one of logical functions that evaluates a certain condition and returns the value you specify if the condition is true and another value if the condition is false. The if function can be nested.
Excel if function another formula. It can also be used to evaluate errors. In this example the formula in cell d2 says.
You are not limited to only checking if one thing is equal to another and returning a single result you can also use mathematical operators and perform additional calculations depending on your criteria.
The if function can be nested. The if function can return another formula as a result. You can combine if with average sum and other excel functions. The if function can be nested.
