Kutools for Excel includes more than 300 handy Excel tools. We have already seen how to use the IF function in basic Excel formulas. Instead of typing each cell one-by-one Excel has the method SUM that you can use.
Again the formula returns the value 10.
With Kutools for Excel installed you can use Operation Tools to quickly apply same formula to range cells. Addition and subtraction are two essential math formulas in Excel. Use the IF function in combination with the AND function and the OR function and become an Excel expert. A function takes an input which is the content of cells plus some operating symbols that say what to do with the data.