Basic Calculations in Microsoft Excel
You use the cell address in Excel to do the calculations. For example, if you have a value ’20’ in cell A1 and a value 30 in ‘B1’, you can display the product of the 2 values in ‘C1’ by typing ‘=A1*B1’ in cell ‘C1’. In case you make a mistake in the entry of the numbers in the cells ‘A1’ or ‘B1’, you just retype the value and the new calculated value is immediately displayed in cell ‘C1’. Of course, if you wish, you can change the formula in cell ‘C1’ to display, for example, the total or sum of the values in cell ‘a1’ and ‘b1’ by typing ‘=a1+b1’ in cell ‘c1’.
Watch the Excel training video below:
Use Excel as your calculator