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!”
Here are some problems that our users have asked and received explanations on
I need to create percentage distribution tables for attendance for the Phillies and the Cubs. Use the same classes for each distribution table so that they can be compared.
Solved by T. L. in 26 mins
i would like to summarize every name in the spreadsheet and the percentage of how many times they appear. I would like to have a column with the names. the other with the percentage of many times they appear.
Solved by O. E. in 16 mins
I want to restrict cells to input a particular Alphabet, basis the percentage calculated in an another cell below in the same row.
Solved by D. Q. in 13 mins
I want to make a cell reference a percentage: so if 88 is 100% I want to see what 77 would be a percentage of the 100%
Solved by Z. Y. in 28 mins
Im creating service staff tip sheet and i want to get a percentage of a cell then divide it by only certain active cells
Solved by Z. F. in 14 mins
I need help with formula to calculate percentage in excel. 1) the percentage of Xs and 2) the percentage of Os against the total number of line items with something in column A
Solved by Z. Q. in 25 mins
My Dec and Jan(end of graph) % on time visual, does not match the percentage lines on left
Solved by B. Q. in 14 mins
A supermarket XYZ is determined to please its customers with a customer advantage card. Currently 30% of all shoppers are loyal to XYZ. A loyal customer shops at XYZ 80% of the time. An unloyal customer shops at XYZ 10% of the time. A typical customer spends $150 each week and the profit margin at XYZ is 7.5%.
The expected increase of loyal customers is 8% and the percentage of time a loyal customer shops at XYZ is expected to increase by 9%. What is the maximum cost of the advantage card per dollar in order for the program to be profitable?
Solved by O. H. in 12 mins
I am looking to return a percentage based of numerous criteria (which are embedded in vlookups). I need the formula to see if a percentage is greater than 0, if so, find the proper segment, rate with that segment, and return the proper percentage.
Solved by O. J. in 26 mins
.i have a list of all course sections with a column for dept and columns for days of week taught i.e MWF TTH, etc and other column start and end time. Do you think it's possible to get the percentage of classes by time slot by dept?
Solved by M. J. in 29 mins