percents

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

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

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%...

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

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

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

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

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