Formula If Statement Excel. Since or only needs one of the arguments to be true the formula returns true. 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.
In this example the formula in cell d2 says. If c2 1 then return yes otherwise return no as you see the if function can be used to evaluate both text and values. Since or only needs one of the arguments to be true the formula returns true.
If c2 1 then return yes otherwise return no as you see the if function can be used to evaluate both text and values.
Highlight the cells you wish to format and then click on format conditional formatting. The apply to range section will already be filled in. 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.
