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

Using Column P (Name + ID) as an Index, I would like to find a matching Name + ID in rows 2-9. Once a match is found, I would like to get the "Entry Fee" value in column D, for the corresponding row, and put it into Column V-AC under the appropriate matching row. I would then like to repeat that and find if that player exists in any other rows and again put corresponding Entry Fee column. After it is all said and done I would like to total all fees (not an issue) and get a percentage of the total fees (not an issue) The gotcha is that some players could appear in multiple columns. QB - could appear in Column E only RB - could appear in Columns F, G, or L WR - could appear in Columns H, I, or L TE - could appear in Columns K or L DST - could appear in Column M only
Solved by G. E. in 12 mins
in our office we have many salesman ..their commission percentage varies with item name and also the number of units sold
Solved by F. W. in 25 mins
Hello, I have a spreadsheet with a bunch of data relating to the pricing of goods. What I am trying to do is add all the costs, then the total costs after multiplying quantities. I am trying to make a percentage of each item cost (relating to the overall cost, out of 100%) in a separate column. How do I do this?
Solved by T. E. in 17 mins
Hello I have a question about how to set up a formula in percentage you please help?
Solved by T. D. in 20 mins
how do I do the same formula for different cells, but i want a different cells value in each of the formulas. For example, if i was trying to find the percentage grade of each student in a class of 300.
Solved by I. W. in 25 mins
I need assistance creating mix of a pivot table and a formula to sort the data I need for that table. You'll see in the file a tab called "Master Pool". This is where all the data will be extracted from. The most important data is column A - Header "Accnum" (this is the data that we'll count in any pivot tables), column O (Header-"Item Type"), and columns V,W,X, and Y (Headers Accessibility (1-4). The resulting report I need has to show the data points in V,W,X, and Y by the data in the column "Item Type". This is the issue I'm having: The data in columns V,W,X, and Y for each accnum is presented in different order, often separated only by a comma. On the tab "A11Y Tag" you'll see all the available options that can go in each one of these fields. The header on those tabs matches the headers on the "master pool" tab. The issue is extracting that data for each item in a way that doesn't show overlaps (i.e.- the same data can be in multiple columns), extracting it in a way that ignores the commas and lack of spaces, and the resulting report will be easy to read. The resulting report must also show a percentage breakdown of items with accessibility data/ and those without. This info is easy to get, it's in column T ("Metadata Present?") on the tab "Mast Pool".
Solved by F. J. in 26 mins
Hello! What formula would be appropriate for this question: Create a formula with structured references to calculate the percentage of the Sticker Price in column E.
Solved by K. L. in 19 mins
I am trying to do a 12month rollover chart that shows 100% per month with one color (total orders) and (percentage on time) with a different color. I am getting some errors and the chart does not look accurate.
Solved by X. U. in 20 mins
Hello. I have a table with testing for 5 different persons. For each test a value meaning number of budget days. In another cell, for each test, the advancement value (in percentage). I would like to have a formula allowing me to have the sum of the work already done - by test - and then total by person. Help?
Solved by D. Y. in 28 mins
In cell H15, enter a VLOOKUP function to determine the 2018 percentage of total attendance for the city listed in cell H14. Use the range A5:H11 as the table array
Solved by D. J. in 27 mins