Excel percentage formula Teaching Excel percentage formula can help you solve various problems every day, from determining business tax (and skills) to calculating increase or decrease. We will do this through the following examples: converting scores into percentages; Deduct value-added tax from the total amount; Increase or decrease the percentage of the total; Percentage of completion; And a percentile. Converting a fraction into a percentage is a part (or fraction) of 100. The mathematical method to determine the percentage is to divide the numerator (the number at the top of the fraction) by the denominator (the number at the bottom of the fraction), and then multiply the answer by 100. For example, the fraction 6/ 12 becomes such a decimal: 6 divided by 12 (equal to 0.5) multiplied by 100 equals 50%. In Excel, you can convert a fraction into a percentage without a formula, just change the format. For example: 1. Enter 10 in column A (from A2 to A 1 1). (Note: Excel will automatically reduce the score to the lowest value, for example, change 6/ 10 to 3/5. Some companies sell products with business tax and then return them to the IRS. The calculation method is to divide the "list price" price (or total revenue) by 1.0, plus the sales tax rate. For example, if you pay $50 for a lamp and the local sales tax rate is 9%, divide $50 by 1.09. The actual retail price before business tax is $45.87, and the business tax is $4.65438 +03. To check your answer, just add these two numbers or multiply $45.87 by 9%. By using the calculator, you can only do this for one project, but if you want to deduct the sales tax from the weekly or monthly product sales, you only need to enter the formula once and copy it into the entire sales and inventory spreadsheet. 1. Enter a dozen products in column A (from A2 to A 14). 2. Next, enter the corresponding total receiving price (including tax) in column B (from B2 to B 14). 3. In the columns "C2" to "C 14", enter several arbitrary sales tax percentages (so that you can use different numbers). Please make sure to enter some decimal/decimal percentage, such as 4.75%, because most business taxes are not integers. 4. Enter this two-step formula in cell D2: =SUM(B2/(C2+ 1)). The purpose here is to convert the tax rate into an integer divisor (for example, 9% into 1.09), and then divide the total receiving price ($ 198.56) by the integer divisor (1.09) to get the correct retail price (before tax)) $189. 6. In cell E2, subtract D2 from B2 to get the actual "conversion" sales tax (for IRS): = sum (B2-D2). Copy the formula from E2 down to E 14. 7. To check your answer carefully, please enter the following formula in F2 to F 14: =SUM(D2*C2). If columns E and F match, the data is correct. If you are self-employed or have an office at home, the IRS uses a method to determine the deduction (the office part is rent, utilities, house maintenance costs, etc. ) is to subtract the office from the total square feet of the house. You can ask for a certain proportion of the total. This arithmetic first divides the square of the office by the total square of the house, and then calculates the expenses according to this percentage. 1. At the top, enter the total square feet of the house in cell B2. 2. Enter the total square feet of C2 office. 3. Enter the following formula in cell D2: =SUM(C2/B2) to determine the percentage of office square feet (25% in this example). 4. Enter your home and office management expenses (rent, electricity, etc.). ) It's in column a5. Enter the monthly cost of each project in column B.6. Enter this formula in cells C5 to C 12: =SUM(B5* 12). This will give you an annual total. 7. Enter this formula in cells D5 to D 12: =SUM(C5*$D$2). Cell address D2 must be absolute. Use the function key F4 to add a dollar sign to make the formula absolute, so every cell in column D is multiplied by D2. 8./kloc-Total of lines B, C and D of 0/3. Now, you can see the whole house, only the monthly and annual management fees of the office. Cell D 13 shows the total deduction of your home office ($5,088.60). 9. To calculate the percentage of total overhead by project, please enter the following formula in E5 to E 12: =SUM(B5/$B$ 13). Use these percentages to determine whether your monthly/annual management fee is within normal business practices. Percentage of price increase or decrease For most enterprises, especially retail enterprises, owners and managers like to know the percentage of increase or decrease of almost everything from sales to wages. Use the following formula to calculate the percentage increase and decrease of the company. Suppose you create a workbook with a spreadsheet label "Add and Subtract". Another spreadsheet label called "SalesTax" contains retail price data. 1. Enter a dozen or so product items in the addition or subtraction column A (or just copy the same items used in the spreadsheet in Part A above). 2. Enter the sales quantity of each commodity in columns B and D.. Enter this formula (C2 to c14) in the "JanSales" column: = sum (sales tax! D2 *‘' increase-decrease'! B2). This formula tells Excel to multiply the retail price called SalesTax in column D of the spreadsheet by the quantity in column B of the spreadsheet where the current cursor is located, that is, increase or decrease. 4. Enter this formula (E2 to e14) in the column "FebSales": = sum (salestax! D2 *‘' increase-decrease'! D2).5. Next, enter the following formula in F2: =SUM(E2-C2)/C2. A positive number indicates the percentage of sales growth between 1 and February, and a negative number indicates the percentage of sales decline. You don't need to spend money on project management software programs, but use the following formula to manage the plan and progress of each project and complete the percentage within the specified time interval. 1. In column A, enter the names of six projects (in progress). 2. In columns B and C, enter the start date and end date of each project. 3. To determine the completion time of the project (so far), please subtract the start date from the end date. Enter this formula in columns D2 to D7: =SUM(C2-B2). 4. In column E, enter the number of days completed so far. This is the only data column that you will change forever; For example, once a day (or once a week), access the spreadsheet and modify the data in this column to get accurate conclusions (remaining days and completion percentage) in columns F and G. To get the remaining days of each project, please enter the following formula in the "F2 to F7" column: =SUM(D2-E2). This figure will constantly change according to the numerical data (days of completion) in column E.6. Finally, enter this formula to get the percentage of tasks/projects completed so far: =SUM(E2/D2). Percentile ranking, imagine that you have dozens of people applying for jobs in national parks and forestry. Judging from their resumes and initial interviews, they all seem to have the same qualifications. However, they must meet some minimum requirements that are not usually pointed out in resumes, such as how to safely remove the bristles from the dog's face and neck. Solution: Test the skills of applicants and use PERCENTRANK to determine the ranking percentage of each applicant. EXC function of Excel. Enter10Applicant's name in cell A2: A 1 1. Enter skill points (scores) between 10 and 100 for each applicant in the cell B2: B 1 1, and then name the range. Select/highlight cell B2: b 1 1. Select formula > define name > define name, and then enter the word "score" in the name box. Click the arrow next to the Range field box and select Sheet 1 from the list to identify the range location. Note that the Reference Field box contains the cell addresses of the highlighted/selected range. If the range is incorrect, click the red arrow on the right and enter the correct range address, or reselect the correct cell, and then click OK.