Step 3Now type equal sign to start. You can just type the symbol and click on one cell you want to multiply eg. Create the Formula Select cell C1 to make it the active cell.
Although the latest version of Excel can accommodate a lot of IF functions multiple IF statements are not the best solution try to avoid it as much as possible.
Instead of typing the constants into your formula you can select the cells that contain the values that you want to use and enter the operators in between selecting cells. Step 3Now type equal sign to start. If we want to insert a formula in Excel then we need to get into the edit mode of the cell where we want to apply and then type equal sign. A formula is a math calculation like 2 2 or 34 1.