percentage

  1. C

    Need cell to perform 'Loop until' calculation and then set final value to a cell

    Scenario looks like this: 3 cells involved: A1 - Formula - Percentage value based on the SUM of three other % value cells (A1 does a simple SUM of three other cell % values) B1 - Formula - Integer value based on simple arithmetic calculation of another cell's value (Looks at another cell's...
  2. N

    3 function formula

    Hello - This is the formula that Ive got: =(COUNTIF(E21:E23,"Y")/COUNTA(E21:E23)/IFERROR(E24,"")) It works great on providing me a percentage until I add in the if error, then the % automatically go to 0. What am I doing wrong?
  3. M

    How to validate total not exceeding the limit with 2 criteria

    In column A I have "Date" In Column B I have "Emp ID" In Column C I have "Percentage" In Column D I have "Trigger" Scenario: I want to mark employee with "Yes" in Column D if the same employee exceeded 100% total in the same date.
  4. A

    Pivot Chart Frustration

    Can anyone help? I am attempting to capture a percentage of a count in a column in a pivot chart. Example: In January 3000 customer service calls were made. Of which 300 were unresolvable. I am attempting to capture what percentage of January's calls could not be resolved and display it on a...
  5. L

    Find decimal-formatted and replace with % in a text cell? Maybe RegEx?

    Hello! I have been working on a report, manipulating and formatting various features using VBA. I received a request I haven't heard before. The exported file contains several columns that contain percentage-formatted values of three or four digits. I'm being asked to join those with text from...
  6. J

    Pivot Table Help- Showing both Percentage and Total as Sum

    I feel like there is an easy built in solution, but I am struggling with this. I would like to show the values as a percentage of the row total, and the grad total for each row as the actual summed value (not 100%). Below is a screen shot of what I get with no calculation, and with "Show...
  7. I

    COUNTIF for multiple data types

    Hi, I have data in excel which contains alphanumeric values like "NA", blanks and spaces, as well as numbers as percentage: For example, I have the 17 values in a column which includes 3 percentage numbers, 11 NA and rest blank values: <colgroup><col></colgroup><tbody> 2.37% NA NA NA...
  8. A

    Calculate row % by subgroup in pivot table

    How do I calculate row percentage by subgroup within a pivot table? <style type="text/css"><!--br {mso-data-placement:same-cell;}--></style> <colgroup><col style="width: 178px"><col width="171"><col width="152"><col width="112"><col width="58"><col width="152"><col width="112"><col...
  9. F

    Compare addresses and show percentage of similarities

    hi guys. im tryign to compare addresses on column A vs column B and needs to show what is the percentage of similarity. this is my code so far, one sheet called CM, sheet2 called ABC, sheet 3 called MATCH copy both to here and show percentage. my code is below but im not sure why something...
  10. JTL9161

    Format Cell

    I have the formula: =A1&" / "&B1 The A1 cell is a number and the B1 cell is a calculated percentage, but my combined result in C1 is 9 / .053125 Is there a way to get it to show a percentage like: 9 / 53% The B1 cell is already formatted to show the result as 53% but that does not...
  11. J

    start date field

    anyone have any suggestions for this. so i am including calculations per quarter. so jan - mar apr-jun etc. what i want to do is pro rata people based on their start dates. so if the person started then pro rata this so they dont get full payments. i am waiting for someone to send me a working...
  12. R

    Help setting a value if another value falls within a % of a range

    Thanks in advance for any pointers! I have a list of Percentages like this: 102.60% 101.90% 101.80% 101.20% 101.00% 100.80% 100.60% 100.50% 99.90% 99.80% 99.80% 99.80% 99.40% 99.10% 98.70% I need a formula that looks at this range and ranks the results 1-5 based on what percentage those...
  13. W

    Trying to work out percentage in a column

    Hello, My name is Byron and I have been given a task and I am having some trouble. I have just joined up today to ask for some help. I have had a go at searching for different posts but cant seem to find what I am looking for, so I hope what I want to achieve is even possible. I have a...
  14. C

    if calc doesn't meet min, auto insert flat fee

    Hello and thanks in advance for any help. I'm trying to create a purchase sheet that includes a set up fee. The fee is either a percentage of the total or a flat fee of $130 whichever is greater. I have the formula calculating the percentage based on the subtotal [=15% * C1] but I want to...
  15. G

    Calculate percentage, ignoring zeros

    <tbody> m n 13 90 14 91 15 92 16 92 17 365 18 33 37% =m18/m13 19 0 20 0 21 0 22 33 814% </tbody> n22 should be 37% n22: 9% -- includes zeros, delivers a wrong percentage =m22/m17 n22: 814% -- Trying to avoid zeros, delivers a wrong percentage...
  16. D

    Conditional Percentage Calculations

    I have a sheet with the following conditions Cell I8 contains a validated drop down list which contains the numbers 1 through 9. Each number represents a percentage to be calculated. Cell P8 contains a dollar amount I want to calculate a percentage for I want cell Q8 to hold a formula that...
  17. T

    Formulat to return certain text from sentence

    Hi, I have the following sentence in A1 "ID1: The change is 0.15% last change is 0.54% (Recommended)" In B1 I would like formula return the percentage in between "is" and "Last". So this would be 0.15% In C1 I would like formula return the percentage at the end. Between "is" and...
  18. D

    time and value question

    Hi All, Thanks for any help on this one. I have a a number of daily logs that show a percentage toner in my cartridge. The percentage falls as i use it over time. I want to be able to see when the cartridge was replaced. But sometimes people can take the cartridge out and shake so the value...
  19. W

    Decrease percentage weekly by week number

    Hi, I would like to use the week number to decrease the percentage by 2% every week. I have the date in B3,Time in D3, Week Number in F3,and 100% in H3. The date,Time,Week number update and run whenever the computer is switch on. Workbook opening script:Private Sub Workbook_Open()...
  20. A

    Parse text from string

    I have a userform label that will display price & percentage ...i.e. -$408.66 (-14.29%). Can someone assist in parsing out only the percentage (i.e. -14.29%) from the string so I can input it into a cell. Thank you kindly

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.
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 "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
Back
Top