To enter the formula in your worksheet do the following. Simply use the SUM function to shorten your formula. This is the default Excel formatting.
Cell C2 contains the number 20 equal to the 02 value.
Type the following formula into any Excel cell. Enter the percentage to be deducted into the neighboring cell B1 in this case. Click the Percent Style button Home tab Number group to display the resulting decimal fractions as percentages. How to subtract percentages.