How to make a formula in excel to multiply number1 by number2. Type a plus sign then use your pointer to select C2 to enter the second cell reference into the formula. Now LARGE will return the top 3 largest values and the SUM function will add these 3 numbers and give us the total.
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.
Type Shift8 on the top row of the keyboard. To start the formula type and then select cell A2. Excel can perform an array of basic math functions and the articles listed below will show you how to create the necessary formulas to add subtract multiply or divide numbers. Instead of typing the constants into your formula you can select the cells.