We can also use the IF function to evaluate a single function or we can include several IF functions in one formula. In this statement there are two operands. To make the simplest multiplication formula in Excel type the equals sign in a cell then type the first number you want to multiply followed by an asterisk followed by the second number and hit the Enter key to calculate the formula.
Enter EDATE A2B2 in cell C2 and copy down as needed.
In the Insert Function dialogue box select Math Trig and under the Select a function drop-down menu select SUM and press OK. In order to get the correct number format use the TEXT function and specify the number format that you want to display. For the multiplication formula using the third way of using the keyboard by writing directly the formula and the address of the cell involved. 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.