Click on the cell where you want the result of the calculation to appear. Type press the equals key to start writing your formula Click on the first cell to be added B2 in this example Type thats the plus sign. Eg formula in cell B5 will be copied.
Type press the equals key to start writing your formula Click on the first cell to be added B2 in this example Type thats the plus sign.
In order to get the correct number format use the TEXT function and specify the number format that you want to display. The most elementary way to do this is to type in the mathematical expression for adding two numbers in a cell. Click Ok or Apply. 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.