1. X

    Converting % data point to different format for notepad extract

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

    Percentage of time worked

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

    Populate random quality assurance checks into a Criteria column based on a set percentage

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

    Getting the right percent when using a Pivot Table.

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

    Sort Pivot Table by Negative Percent Values

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

    excel formula for 20% of the sum of column

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

    Find automatic value that multiplying with a percentage will return me the value I want.

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

    number to percent format

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

    calculation method

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

    IF AND Formula with a Date and 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...
  11. U

    Pivot table question

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

    Percent of Total - How to build report

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

    Percent change in price

    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?
  14. M

    VBA text box source from cells

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

    Payment plan, with 2 accounts, paid in order

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

    Percent of a number from a total number

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

    Percentage of Cells starting with a range of numbers

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

    Solving for 1st Occurrence in a row

    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%)...
  19. J

    Calculating Negative numbers for budgets

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

    Pivot Table -> Show Value As -> % Of (Cumulative)

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

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
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
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