To calculate a basic percentage in Excel, use the “Percent Style” button under the Home Tab>Number Group and apply it to the column where you’d like to display the percent (e.g., column D). Use the formula C2/B2 in column D to calculate the what percentage of the number in column B is represented by the number in column C. For example, if column A specifies your product, column B might represent the total produced and column C might be the total shipped. If B is 75 and C is 69, enter C2/B2 in column D to get 92%.