# percents

1. ### 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. ### 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. ### 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. ### 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. ### 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. ### 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. ### 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. ### 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...

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back