1. P

    Calc percentage of goal if looking to decrease from actual.

    I've been off work a while and I just want to make sure I'm doing it properly. Goal call hold time is 300 seconds but actual is 660 seconds. I want to calculate progress toward goal of 300 seconds as a percentage. I have 45% as the achievement toward that that correct? Note: in the...
  2. R

    Rank table of Percentages from another table.

    Hello, I want to rank lists of percentages that include ("N/A", Negative and Positive % Values), based on the highest percentage that has to be 1st and lowest percentage (till highest negative percentage) last, if the value is "N/A" return "N/A". The rank should relate to the symbol. I want...
  3. B

    Percentage increase from a negative number to a positive one

    Hi, I'm trying to work out the percentage increase from a negative number (-21) to a positive number (941) but I'm very confused...can anyone help please? Thanks Richard
  4. S

    Help with finding the position of a value as a percentage

    Hi all...I have a query that I'm struggling with, I'm not too sure if I'm going too technical too quickly tbh! I have some values laid out in a table similar to below, I need a formula that can automatically calculate the position of the value in % form. Min Max Value Position % 50 100 75...
  5. F

    Calculated measure in Pivot Table

    Hi! I´ve been trying to get a measure in my pivot table to get the % of reject orders of a partner / Total order order of partner, and that it can change if I use a slicer to change it by day, month, etc. This is an example of the data table which I use: And this is the pivot table which I...
  6. F

    (Simple) Showing Labels in UserForm as percentage format

    I created a userform that displays certain values within row of the active cell, as a quick reference in a lofty spreadsheet. Right now it shows all values as regular numbers (shows "1" instead of "100%"), even if the referenced cell is a percentage. Code below --- i want Label9 to show up as a...
  7. J

    Conditional Formatting Gone Wild

    I am losing my mind over this. I am very well acquainted with Excel; however, this super basic formula is killing me. Have I completely lost it?! We get a task on certain dates (DATE) and depending on the task, it may either have a 75-day suspense or 180-day suspense (STANDARD). To find out...
  8. S

    How to workout the error rate or percentage of a spreadsheet using a specific value as reference?

    I want to be able to calculate the rate/percentage of error. I have 3 sheets: Master, Co-Master and ReDo. Both the Master and Co-Master sheets have a total time column (J) to give the total time a user has taken to complete a task. The ReDo sheet is solely to record issues with the Master or...
  9. N

    Formula to Calculate Shares

    I am trying to calculate the amount of shares I can purchase using the formula below. However, when I use a calculator the amount of shares to buy is different from the excel shares to buy. What am I doing wrong with the formula? Thanks for your help. =(A2*B2)-C2/D2 or =A2*B2-C2/D2 Account...
  10. T

    LTV Maximum Loan

    Hi, this should be really simple but it's hurting my head. I have a known amount of savings (lets say £50,000) and some known LTV percentages from a mortgage company. 70% LTV Interest Only 75% LTV Part & Part 85% LTV Repayment I would like to know the maximum loan amount based on the...
  11. R

    Average on percentage but with different weightings

    Good day. I'm busy with performance reviews for staff but are battling with the following. Section 1 for instance gives me an achieved percentage of 80% and the weighting for this section is 50. Section 2 has a achieved percentage of 40% but the weighting for this section is only 30. Section 3...
  12. S

    Create a dollar value from a range of values that are capped

    Hi All, I am wanting to create a formula that calculates a fee dependent on the value of the sale. Where Cell A1 would be the value of the sale 0 - 29,999.99 Capped $500 30,000 - 49,999.99 2.5% Capped $1,000 50,000 - 99,999.99 1.9% Capped $1,500 100,000 - 149,999.99 1.5% Capped $2,000...
  13. A

    Reverse Engineer a formula

    I have the following cell data. A2 = 108.59 B2 = 20% C2 = 27.15 C2 has the following formula in it: =A2/(1-B2) - A2 this gives me the 27.15 What I want to do is have in D2 a hard value of 23.00 and then in E2 I want the % value based on the formula in C2. IE - If C2 was 23.00, what would B2...
  14. A

    Percentage Color Coding Question

    I have a column of numbers (in percentages) which is a part of a pivot table. I need to color code this column as follows: - Percentages above 95% "Good" - Percentages >= 90% and lower than 95% "Neutral" - Percentages < 90% "Bad" I would like to use Excel Styles for colors. I have written...
  15. B

    Need a formula - filter so 2 columns totalling more than or close to another column only show

    Column I in my excel file shows unpaid invoices. Column K shows uninvoiced items. Column P shows the customer's balance on account . Most of the time, P should be greater than I+K. However we want to be able to easily spot the customer files that are close to or have exceeded the customer's...
  16. H

    Excel formula to modify the percentages (say discount) so that final sum after the discount is within the budget

    After applying discounts (x%,2x%,3x%) to premium, the final discounted premium price is 1.1 million. But maximum final discounted premium price that I can give is 1 Million. Now, how to adjust the discounts (x%,2x%,3x%), so that my final discounted prices is exactly 1M Note: I have to use only...
  17. J

    Getting a total number from a percentage.

    Hi all, I have attached a screenshot of what I want to do. Essentially, I want to populate Column G with numbers which relate to percentages in Column J, they are percentages of the number displayed in cell G28. I found this hard to explain so if you need any more information, please let me...
  18. M

    Pivot Table: Calculating Average % Across Years

    Hello, I have a Pivot Table with Years as the top-level column, then two fields underneath, Cash and Operations. The values in each field are currently calculated as % of Parent Column Total, so Cash and Operations are shown as percentages of each year's total. I would like to also create a...
  19. H

    Percentage Question!

    Howdy all! So I am trying to figure out how to make this idea a reality. I'm not even sure that I can but I figured I would ask the web of experts and see instead of screaming silently in my head over and over. Idea: I want to be able to calculate the percentage of vehicles in my squadron...
  20. S

    How to set the Pivot Table Layout

    As shown in below Table. "F" has sold 2 items out of which one is defective. i.e. 50% of what he has sold is defective. How do i represent this in Pivot Table? I am unable to figure out the Layout. Raw Data: Sales Executive Products Sold Defective F XYZ NO D XYZ NO F XYZ YES C XYZ...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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