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

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

I am trying to get my percentages narrowed down. For example. 25% x 90 should be 22.50%, but I keep getting 2250.00%. When I go to the Ribbon and click the percentage sign it will not go down. please help
Solved by K. W. in 14 mins
I want to count the number of cells in COLUMN F that are conditionally formatted to red, and then find the percentage of total cells in COLUMN F that are red. This can be placed at the bottom of the column. I want to automatically delete the YES value in the cell in COLUMN F once the date in COLUMN E has passed.
Solved by T. C. in 14 mins
On Tab "Employee Information" I need Column V to use the if formula from Column P to decipher whether the Employee file Single "S", Married "M", or Do Not Withhold "DNW". Once it deciphers this, if the answer is "S" I need it to lookup the tab "Payroll Calculator" AG4 for the first Employee, and find the Gross Taxable Percentage from the named group "SingleFedTaxTable" or tab "Data" range H14 through I20, to find the percentage on J14 the J20. If the answer is "M" I need it to lookup the tab "Payroll Calculator" AG4 for the first Employee, and find the Gross Taxable Percentage from the named group "MarriedFedTaxTable" or tab "Data" range H26 through I32, to find the percentage on J26 through J32. If the answer is "DNW" I just need it to answer with a 0.
Solved by O. L. in 23 mins
On Tab "Employee Information" I need Column U to use an if formula from Column P to decipher whether the Employee file Single "S", Married "M", or Do Not Withhold "DNW". Once it deciphers this, if the answer is "S" I need it to lookup the tab "Payroll Calculator" AG for the Employee's Taxable Gross Wage, and using this number find the Gross Taxable Percentage from the named group "SingleFedTaxTable" (or tab "Data" range H14 through I20), to find where the The Taxable Gross Wage falls between the H and I columns on the Data tab, the percentage on J14 the J20 from the row which the The Taxable Gross Wage falls in between then needs to be displayed on the "Employee Information" in column U. If the answer is "M" I need for it to do the same as above, but using the named group "MarriedFedTaxTable" or tab "Data" range H26 through I32, to find the percentage on J26 through J32. If the answer is "DNW" I just need it to answer with a 0. If there any way this can be worked out?
Solved by D. Y. in 21 mins
how to calculate percentage change in excel? I need a column to calculate a percentage in the pivot table for each year, and then also for the totals columns. The percentage should be percentage of claims with CAT code out of the total amount of claims. Example the percentage of column C/B, E/D, and G/F.
Solved by K. D. in 16 mins
I'm looking for a formula to remove a fixed percentage every year. For example, if I have a value of $1000 that is 2 years olds with a 10% decrease per year, my result would be $810.
Solved by F. H. in 21 mins
Hello,I have a historical time series going left to right. I have about 50 rows and 3,000 columns for each day. I have a column at the end that shows the max value in each row. I want every other value expressed as a percentage of this number. So I already have a blank row in between each populated row where I want these values. Not every space is populated, so I just want a percentage beneath each box that is populated. Can you please help me?
Solved by B. E. in 28 mins
need to extend rows database tab please only extend the rows and formulas where highlighted in RED need to remove percentage table from 'summary all ids' tab and place in new 'summary single id' tab and create a pie chart based on percentage data- see cells in red for further notes
Solved by T. C. in 27 mins
i need to answer (Q11: As a percentage, what was the growth in population from 2000 to 2010?) using a formula. Please help me find the growth percentage formula.
Solved by T. E. in 20 mins
i need to answer Q12: Which country had the larger population growth percentage? with a formula
Solved by Z. Y. in 14 mins