You can also enter formulas by using the point mode where you either click on a cell with your left mouse button or you use the arrow keys. In some cases you can skip the SUM format and simply type in the function input like A1A2. This formula divides the value in cell A1 by the value in cell B1.
For example there are several ways to enter formulas and calculate numbers in Excel.
Excel Formulas Cheat Sheet. See the SUM function for adding multiple numbers. A1A6 this Excel formula adds the contents of cell A1 and A6 A1A2A3 this Excel formula adds the contents of the three cells specified. In Excel a formula is an expression that operates on values in a range of cells or a cell.