As with any formula in Excel you need to start by typing an equal sign in the cell where you want your result followed by the rest of the formula. Cell C2 contains the number 20 equal to the 02 value. Lets check out them.
Inputting IF-THEN in Excel The IF-THEN function in Excel is a powerful way to add decision making to your spreadsheets.
You can create a simple formula to add subtract multiply or divide values in your worksheet. Add to formula with Kutools for Excel. In addition to doing pretty complex calculations Excel can help you do simple arithmetic like adding subtracting multiplying or dividing any of your data. The most elementary way to do this is to type in the mathematical expression for adding two numbers in a cell.