Get instant live Excel expert help to learn how to calculate percentage in Excel

Need help regarding percentage complete excel. I need to calculate 2 totals against a final total in percentage to monitor progress for example cell d1 + e1 = total percentage completed against final figure in F1

I need a problem solved.. I need to find out if someone scores 22/40.. what percentage of say 6.5% that is.. what's the formula?

I need a formula that will generate a percentage based off a chart of numbers. This is for a commission percentage reporting. So basically if the gross profit margin is 60%, the commission will be 15%. If the gross profit margin is 40%, the commission will be 5%. I have a cell that I will manually be entering the gross profit margin, so now I need a function that will generate the commission percentage based off what I type into the gross profit margin cell.

Add a primary value axis title and type Number of Downloads. Add a secondary value axis title and type Percentage of Monthly Downloads. Apply Black, Text 1 font color to both value axis titles.

I want to create a circle or square that will color in when I enter a percentage in the cell.

I have a spreadsheet that has data set up for each week of the year. I am trying to figure out to have an automated formula that it calculates new percentage to goal based on the weeks as they go without having to manually do this every week.

Design a workbook named sales_LastNameFirstName to help you track your weekly sales commission. Your name should list in cell A1 in an enlarged font size with a different color than the default color merged and centered across all columns used. Display in a labeled cell your weekly base pay as a salesperson. Display in a labeled cell the amount of commission earned the previous week. Your company pays commission based upon the number of sales made in the week. The commission rate is then multiplied by the weekly base pay to compute commission amount. An English description is given below of commission rates. Use that data to create a lookup table placed on the workbook. Add a box border around the lookup table. Number of Sales Commission Rate 1-9 3.0% 10-19 3.5% 20 or more 3.8% Include column headings for date, number of sales, commission rate, commission amount, and total pay. Format the column headings row with some border in a different color than the default color and each entry boldfaced and center-aligned in its cell. Include five rows of data for the five business days Monday - Friday. For the first row, enter a particular Monday date and for remaining rows, add 1 to the previous date to compute the new date. Use the VLOOKUP function to compute the commission rate for each day based on the number of sales. Compute the commission amount from the commission rate and the base weekly pay. Compute the total pay as the sum of base pay and commission amount. Under the rows add a labeled cell and display the sum of commission amounts. Use the IF function that compares commission amount earned this week to the previous week's value and reports some congratulatory message if the current amount exceeds the previous amount, and some other message otherwise. Format the message in boldface in the same font color as your name. Use Currency format with two decimals on all money amounts. Use Percentage format with one decimal on all percentage values. Insert a small money-related image to the right side of the row data to fit the size of the five rows. Rename Sheet1 appropriately and delete unused sheets. Add a header of your name in the left side, sheet name in the middle, and current date on the right side. Your workbook must be unique and reflect your own data and design.

I need a formula that extracts percentage and decimal numbers only from a text string. The text sting will contain other types of numbers also like dates which I do not want to extract

I have a spread sheet with column data. I need to create a formula, likely an offset, to minus one row from from another as we add data to the columns weekly. Also an offset for a percent change formula

I'm trying to calculate final sales price when what I have to start is the cost... and I'd like my final sales price to include 15% for overhead and 10% for profit. I want to show those as discreet line items. And I want formulas that calculate a change to either percentage.