If it is you can make the formula return the text PERFECT If it isnt you can make the formula return TOO SMALL. 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. Now that you are familiar with the IF functions syntax lets look at some formula examples and learn how to use it in real-life scenarios.
How to use the SUMIF Excel Function.
The formula to use to get the total sales for East is. Select cell B4 to make it the active cell. In this example the formula in cell D2 says. The formula in D6 copied down is.