1. F

    Time Percentages

    I am working on a spreadsheet for my company that is requiring me to track the downtime of our trucks. I want to create/use a formula that will give me the time for 24, 48, 72, 96, 120, and 168 hours. So basically the total amount of hours would have to change everyday per formula. I have...
  2. B

    Multiplying and Summing percents ignoring Text in some cells

    In row 2 I have assigned weighted percents to multiply each row's current percent complete in columns Column J:S. Column T is my sum of all of them and is where my formula is. Currently I have to count a category as 100% even though it should be NA. I have tried iserror, isnumber, etc and have...
  3. A

    Help! With new percentage of a number within limits

    Im working on a spread sheet for work regaring satifaction scores. All scores are shown in percentages. What I am trying to do is come up with an equation that will tell me how much the site needs to go up by IF within a certain percentage range. Example: I have scores of; 92.25% 94.90% 82.25%...
  4. G

    Formatting Numbers to percentages and -percentages as (x.x%)

    Hi All, I am using Excel 2010. I have a bunch of numbers that need to be turned into percentages. I also have - percentages I need to display as (x.x%). Example 29.03 wants to show up as 2903%. -29.03 I wants to show up as -2903.0% If you look in custom formats and do 0.0/% it shows up...
  5. R

    Incremental increase by week when the total for month is known

    I have been a long time lurker of MrExcel, but have always been able to find the answer to my question within the forums. However, I am stumped. I am trying to create a pivot table that will show incremental goals by week, when I have a set goal for the month already. However, I don't want to do...
  6. P

    When a small number is ranked greater

    I am trying to do an excel spreadsheet and in my case we are doing a study of per capita income in different regions. 1 is of course best. 3141 is worst. However, excel wants to make the best ranking ( 1 ) flat and it makes it appear that it is not the best ranking. I also neeed to know how to...
  7. T

    How to add and subtract a number with percent

    This is my situation: I have a table where I need to enter random general numbers (product costs) and subtract and/or add percentages. It has to do with a price sheet, I have a price to which I add VAT and/or subtract sale and rebate in % of different values. The 'sale' and 'rebate' fields are...
  8. P

    Percentage: Duplicate Enteries -2 Parameters

    Hi, would really appreciate any help on this…I have read few articles in the various treads and having trouble resolving below scenario:<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> I would like to find calculation for the Anticipated Outcome column...

Some videos you may like

This Week's Hot Topics