Percentage of a total
=B2/C2Divides the part in B2 by the total in C2.
Calculate percentages, percentage change, and increases in Excel with practical formulas and correct percentage formatting.
Direct answer
Divide the part by the total, then format the result as a percentage. If the score is in B2 and the total is in C2, enter =B2/C2 and apply Percent Style.
=B2/C2Divides the part in B2 by the total in C2.
=(C2-B2)/B2Compares the new value in C2 with the original value in B2.
=B2*(1+C2)Raises the amount in B2 by the percentage stored in C2.
Ctrl+Shift+%Applies Percentage format to selected cells in Excel for Windows.
Press ⌘+Enter to submit
Need more than a single How To Calculate Percentage In Excel formula? Try our free AI for Excel — it reads your entire spreadsheet, answers questions in plain English, and builds charts and analysis in the same chat.
Cell D2 divides 42 correct answers by 50 total questions and displays the decimal result as 84%.
| Student | Correct (B) | Total (C) | Percentage (D) |
|---|---|---|---|
| Avery | 42 | 50 | 84% |
| Jordan | 38 | 50 | 76% |
| Sam | 47 | 50 | 94% |
Put the part or achieved amount in B2 and the total possible amount in C2.
Select D2, type =B2/C2, and press Enter.
Select D2 and choose Home > Number > Percent Style, or press Ctrl+Shift+% on Windows.
Drag the fill handle down to calculate the percentage for the remaining rows.
Check a percentage and see the calculation steps.
Calculate sale prices and savings.
Use the same ideas in Google Sheets.
Rank values from highest to lowest or lowest to highest.
Browse the complete Excel formula library.
Compare your options
Open a neutral research prompt in the AI tool you already use. Compare capabilities, limitations, and fit before you choose.
AI answers can be incomplete. Check source links, current pricing, and product documentation before deciding.
Sign up for Formula Bot and get unlimited AI-powered formula generation, explanations, and advanced data analysis.