1. E

    Normal distribution - percent

    Hi! I'm trying to create a table from 5 to 36 columns (months). Each column should add up to 100%. The problem is that in each column I want the distribution of “percentages” to be normally distributed. For instance in colum 7, I need 100% to be close to normally distributed over 7 rows (For...
  2. A

    formula to increase value by a percentage

    I need to enter a formula that increases the value 1799 (F5) by 20%. Please help! I know it sounds silly but I have such a hard time wrapping my head around percentages =(
  3. L

    Pivot Table - Showing subtotal as both percentage and sum

    Hi, I have had a decent google and haven't managed to find an answer that suits my problem. I have created a pivot table with 2 columns of data (as an example). I have added a subtotal to the row of data which is just summing the row label. Like this example for a debtors report: Row Label...
  4. B

    percentage problem

    I need for example 1,000,000 = 100% So i need if someone enters 500,000 in A1 then it will show 50% in B1 I am unsure how to put this formula together
  5. S

    give a 5% discount help needed please

    I have a excel 2007 spreadsheet that works out a total of a customers order, how do I get it to give them a 5% discount. so if their total in B29 = £423 I would like b30 to give me the amount with the 5% discount deducted. Hope this make sense thanks in advance
  6. L

    Percent to total next to each other

    So I have data which I'm recapping in a pivot table and I'm using show values as percent to total. The issue is that I have the data over multiple years and I'd like to compare the same months penetration year over year. As of now I have the months across the top and I have years on the...
  7. D

    Percentage Increase

    I need a formula to work out a percentage increase from one cell to another for example. Cell A1 = 10 Cell A3 = 15 Cell A4 = 50% Thanks in Advance! :)
  8. D


    If i have A1 and i want to minus 30% off what would be the formula? Can anybody help please?
  9. L

    Percent markup and discount in a range

    <P style="MARGIN: 0in 0in 10pt" class=MsoNormal><FONT size=3 face=Calibri>Background: (1) I have a (Windows Vista) 2007 Excel worksheet with 14 columns and 2,354 rows, for a total of 32,956 cells. The file’s size is 304KB. Alone, the file serves as our parts and price list for our wholesale...
  10. Z

    Excel - Percent of Totals

    I have a problem with percent of total in excel... ....................January.........February.......... March ........ Product Total .......... % of Total Toppings ...... $19,314 .......... $21,698......... $18,742...
  11. A

    Macro that ranks data as a percent rank

    Hi guys, I've been working on a project and have hit a little bit of a brick wall. I have many problems at the moment, but the following is the most important thing I have to deal with. If someone can do this I'll be amazed as I've asked so many people and no one has any idea how to go about...
  12. G

    VBA code in Excel opens Word template and fills bookmarks, but can't get percent formatting right!

    Excel is my source document which contains my data. Word is my template with my bookmarks. I have created a macro in Excel which opens my template and populates my Word bookmarks. The problem I am having is my data in Excel is a percentage (out to 2 decimals) and when the bookmarks in Word are...
  13. G

    Access Pivot Table to show % of all records when only top 10 items are shown

    Dear All, I am using Access 2007 and am at best an intermediate user so please be detailed in your response. I have a pivot table where I show the top 10 customers based on the sume of open sales orders. The fields are Customer Name and Sales. I added another instance of Sales and have the...
  14. M

    Simple VBA percentage

    Ok, so I have the following data on a sheet. <table border="0" cellpadding="0" cellspacing="0" height="147" width="329"><col style="mso-width-source:userset;mso-width-alt:5006;width:106pt" width="141"> <col style="mso-width-source:userset;mso-width-alt:2645;width:56pt" width="74"> <col...
  15. 4

    Data label different than actual number in graph

    How do I change a data label to read different than the actual numerical value in excel 2007 graph. i.e number in my axis that increase by 20's, the bar graph reads whole number, but I want to place a data label that reads a percent of the total over each bar. Does anyone know how to do this?
  16. C

    Problem with ComboBox in percentage

    Hi all! <o:p> </o:p> I’m new to this forum and also VBA so be gentle! ;)<o:p></o:p> <o:p> </o:p> I have an excel sheet with a button linking to a form that gives input to a calculation done in the sheet.<o:p></o:p> <o:p> </o:p> One of the inputs in this form is ComboBox1. The source...
  17. E

    how to drop grades

    This is what I have so far: column E is for Quizzes and column I is for Labs. Quizzes (col E) counts for 10%. Labs (col I) counts for 20%. I want to drop the lowest 4 grades out of all the labs and quizzes for each student. For example, if the lowest 4 are all quizzes then no labs get dropped...
  18. K

    Is there a way to add Percent Values to a stacked column Chart?

    Is there a way to add the % values that each section of a stacked column represents that is easier than individual text boxes?
  19. B

    Advanced Commision Calculator

    Hi Everyone, I'm trying to calculate the commission for work and I'm getting Really long formulas. it works like this Excel WorkbookIJKLMN77*IF****78*GPIF***79*0.25 on the total valueGPIF**80**0.25 on 300000GP>500000* * * * * * * *240,000.00*81**+ 0.3 on the difference0.25 on 300000* * * * *...
  20. R

    dsiplaying %

    I need to display two percents in a single field. I've use =E64&"/"&F25, where the two percantages are in the two referenced fields. This displays as 0.69/0.70. Anyone know how I can make this show 69%/70%? Thanks, james

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...