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 need a formula to calculate the average percentage from another sheet.
Solved by Z. U. in 14 mins
I would like to know what the unit of measurement of the standard error in my regression (using data analysis tool) - a percentage or in the units of one of the variable, if so which one (x or y)?
Solved by I. L. in 29 mins
My students have just completed a test. I want to analyse their incorrect answers. I have created a spreadsheet in Excel. Some of the questions are all based on the same subject. If for example questions 1, 2 and 3 were all based on 'punctuation', I want to see the number of incorrect answers in the 'punctuation' category (e.g. questions 1, 2 and 3) combined but as a percentage of 26 (the total number of students who took the test). For some reason, the total percentage keeps going over 100% and I don't understand why.
Solved by F. A. in 27 mins
Hi I am having some difficultly creating a graph that shows different total numbers and the percentage associated with that total number. For example, my totals are 217, 207 and 10 and I need each to have a different percentage 63.8%, 64.3% 55.6%. I tried adding a secondary axis but this generates a visual that is misleading because for example the line that overlays the bars will fall way above the smaller total which makes it look as if over 100% was capture when it is only 55.6%. I am not sure if any of this make sense but I thought it would be worth a try.
Solved by E. J. in 22 mins
In cells F6:F13, how do I add a VLOOKUP function that will return the raise recommendation- High, Standard, or Low- for each employee by exactly matching the Name in column A in the range I named Evaluation (A3:J10 on evaluations tab). I have to make sure to use exact match criteria. Also after that VLOOKUP function.In cells G6:G13, how do I add a VLOOKUP function that returns the starting raise percentage based on the ranges in the Standard Raise table in cells A16:B19 and the number of years employed in column E?
Solved by B. B. in 15 mins
In cells G6:G13, how do I add a VLOOKUP function that returns the starting raise percentage based on the ranges in the Standard Raise table in cells A16:B19 and number of years employed in column E?
Solved by F. W. in 11 mins
I need to do a nested if function that increase a number by a percentage if it is between two numbes
Solved by I. D. in 15 mins
I need help with being able to select a county in a drop down box, then excel generate a salary based on a percentage, average salary for a county, and use the alabama salary average to generate a total number
Solved by E. J. in 11 mins
Hi I have 200+ shipments listed and my boss wants the percentage of shipments that were shipped in 10-15 days and those >20 days (nothing over 100 days) in a pie chart but I have no clue how to do this
Solved by C. J. in 23 mins
I need help on some excel work including central tendency, dispersion, percentage increase and decrease calculator. I have attached an excel file with the questions and the data.
Solved by G. E. in 14 mins