The dialog box takes care of the syntax such as placing comma separators between arguments and surrounding text entries in quotation marks. For example SUM for getting the total sales. To type a formula click in any cell in Microsoft Excel and type the equals sign on your keyboard.
Type an equal sign the cell or in the formula bar.
For example SUM for getting the total sales. For example just type 2 2 in a cell of your choice and Excel will perform the requested calculation. Enter an old number in cell A1 and a new number in cell B1. Type a plus sign then use your pointer to select C2 to enter the second cell reference into the formula.