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. 1 First open an Excel spreadsheet and then double-click on cell A1 to type your function. The Sum value will only display the sum of all selected cells.
You can also hold Ctrl and click each cell you wish to select.
For example just type 2 2 in a cell of your choice and Excel will perform the requested calculation. 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. The YEAR function looks at the date in cell A2 and returns 2019. Arithmetic in Excel 1.