Calculations in Excel Step 1. To subtract use the - sign. Select the cell containing the number of which you want to find 10.
This tells Excel that you are entering a formula not just numbers.
In Microsoft Excel formulas constants are numbers dates or text values that you enter directly in a formula. To calculate statistical variance in Microsoft Excel use the built-in Excel function VAR. Use the equal sign to calculate. In addition to doing pretty complex calculations Excel can help you do simple arithmetic like adding subtracting multiplying or dividing any of your data.