Formulas can be simple arithmetical formulas or complicated formulas involving conditional statements and nested functions. How to make a formula in excel to multiply number1 by number2. To create a simple formula in Excel.
Select the cell where the answer will appear B4 for example.
Create a simple formula in Excel On the worksheet click the cell in which you want to enter the formula. Select the cell where the answer will appear B4 for example. Type the equal sign followed by the constants and operators up to 8192 characters that you want to use in the. POWER in Excel Example 3.