On the Home tab in the Number group click the percentage symbol to apply a Percentage format. For example if you want to calculate 25 of 50 multiply 25 by 50. Type the following formula into any Excel cell.
Select the cell containing the number of which you want to find 10.
As with any formula in Excel you need to start by typing an equal sign in the cell where you want your result followed by the rest of the formula. C3-B3B3 The brackets around the subtraction part of the formula ensure that calculation occurs first. When you start typing average you will get a few options to choose. How to calculate percentage in Excel Select an empty cell where you want the answer displayed.