percent

Hi I have a macro to extract data from excel to a very specific format in a notepad doc. Most of it is fine but struggling with best way to convert 1 data point. It's a percentage in excel but the extract must always be 9 characters, eg below: 0.05228% = 000005228 0.52280% = 000052280...

Hi! This is my first post here and I am sorry if the question has already been asked and answered. Couldn't find anything for this. Anyways! I can't figure out how to get the % total of hours worked. The formula for total is: =SUM(L85:R85) ,for example. How do I make that into percent if a the...

I am attempting to populate random quality assurance checks into a Criteria column, if there are less cells populated with a Criteria (High Cost, High QTY) than the required (say 10%) quality check, then a "RANDOM" will be the cell's value. I can't wrap my mind around how to accomplish a...

I am currently looking to calculate a savings percentage. To do this, I have created a pivot table that adds Column A- All of Company A’s billed costs. Column 2- All of Company A’s reviewed cost savings Basically, there is a review process and column two has what we were able to reduce based...

Hello, I have a Pivot Table that I created showing Year over Year (YOY) changes and I would like to sort this Pivot table to show Negative Values on top. I am showing years 2019,2020,2021, and 2022 and I would like to show the negative(YOY) for each year on top of the table. Is there a way to...

hello, is this possible? I have a bunch of numbers in a column, lets say its from I4:I20 Now in I21, I want to get 20% of the sum of I4:I20 - is that possible with a formula? Now if yes, a potential added complexity... the range of cells will actually be different every time. BUT the constant...

I have a product that costs 48.41 and that's how much my supplier charges for the product. I need to add 60% on top of this value, which will give me the result of 77.45. But when I do 77.45 - 60%, instead of returning 48.41, it returns 30.98. I need to make cell X calculate which value...

hi, i am tring to conver number to percent but its not happening its showing as numbers please help me out this and also i want to aply a condition if based on percent if above 50% the cells should be red and for DIO if its > 30 days it should be red when i am tring in F8 its working but when i...

hello, i would like to know if there’s an equation to help me automatically calculate/multiply any extra 1 percent after 100% with 1.5 as factor for the extra 1 percent

I am trying to create an IF AND formula that looks at a cell with a Date to see if it is 30 days from Today and then looks at another cell with a ranking percent and return true/false text. Below is my formula which is not working. =IF(AND(D2=TODAY()+30,G2<0.8),"OK","REVIEW") What is a better...

Hi there, is there anyway that showing data "as a percent of' will relate to the entire dataset? Meaning, for example, that if I have a data-set of car models sales by car makers and I choose to filter 'Audi' in the pivot-table- The percent of sales for A3 model will be in relation to the...

Hi, I have some task - that looks like very easy, but... I cannot find solution :( I have data like this: <tbody> Column1 Column2 A No A Yes A No B No B Yes C Yes C Yes C No </tbody> And want to get report showing the percent of Yes/Total: <tbody> Column1 Yes/Total A...

So I have an item that we have received many times and would like to create a table using a measure listing percent change and date. IE received at $1 Jan 10 then oct 8 $1.25 then nov 22 $1.30.... Showing the date for each. Something I’m guessing with min?

Hi. The below VBA is part of a code to create a text box and populate with content from two cells however I’m looking to alter to include: The cell V9, contains a number 0.5, and the cell is formatted as a percent, 50%. I need the above code to present as a percent in the text box rather than...

Hello! I am having a hard time doing this in excel, and variations of it::confused: how can i calculate the monthly price i need to pay to pay down 2 accounts 2 0 where the 1st account is worth 2000 and has 0 percent interest and the 2nd account is work 10,000 and has 5 percent compounting...

Hello, I am trying to figure out how to calculate a percentage by taking a total number and figuring out what percent of it is another number. Example: <colgroup><col width="56" style="width:42pt"> </colgroup><tbody> 31 20 19 17 15 15 15 14...

I have a project that I'm working on and running into a problem. I am trying to calculate if a phone number starts with specific area codes. I want to count them and get a percentage of the total ones in a sheet that i can add to. I would like to eventually do conditional formatting for easy...

I am trying to display the number in the cell above the row of percentages that 1st hit above a particular percent. <colgroup><col width="64" span="10" style="width:48pt"> </colgroup><tbody> 1 1 2 2 3 3 4 4 5 5 1.05% (1.01%) 0.90% (0.85%) 1.30% (0.75%)...

Hello I have a budget for 2019 and want to distribute it across the year based on historical data (2018) With positive numbers on the numerator and demoniator it is very simple to do this. But when there is a negative from a month or for the year I am having some serious issues. These are not...

Trying to find a workaround to show a cumulative '% percent of' (currently using 'show values as'), so running up to 100% by the end of the year, hopefully more if we exceed sales expectations. I have uploaded an example of the information i am working with as it may help to see the data - I...