1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. A

    Formula to convert currency cost into a percentage

    Hello, Which is the correct way/formula to convert the currency cost into a formula. For example: $39.21 shows as 3921% - May I know which formula I should use to get the percentage in a correct way. These are the sub-totals cost I have and I would like to show them in a percentage form...
  7. N

    How to convert hours worked on a task into percentage

    I'm working on a time study. I need the formula to convert numbers of hours worked on a task in an 8 hour day into a percentage.
  8. M

    Score based on percentage value from range percentage

    Good day, I know I can make this simpler but I am sending this out to the world of the company and need to keep it "concise". I need to have a value "score" selected based on % given however, the options to pick the value "score" needs to be obtained using the range below A B...
  9. A

    Conditional Formatting - Icon Set

    Good afternoon everyone, I'm thinking this is an easy question but I'm having a brain fart and can't figure it out. Basically I have a spreadsheet where I need to have a red light whenever the percentage is less than -8% and a green light whenever the percentage is more than 8% and have no...
  10. D

    Percentage of a percentage?

    I better explain this right, i would like to present in a cascade chart the participation of a category in the percentage fraction out of goal. Any guide will be highly appreciated. From the table below in PowerBI I have the following: On Goal = 8/18 = 44% What i would like to present is the...
  11. M

    How to distribute the value with a percentage

    How to distribute the value of 30 with the following Percentage: A 19.6% B 13.5% C 15.7% D 3.2% I want to get the same value of 30 for A,B,C& D
  12. N

    IF formula

    This formula is supposed to test if one cell value is less than another, if so, show nothing, if not, then do a percentage calculation and show that, what am i missing? =IF((AZ2<$AX$7),(""),(("BA2/AZ2)*100"))) Happy to share the spreadsheet if it helps, it's nothing personal. Here's how it...
  13. G

    Calculate EXACT number to achieve an EXACT percentage

    I know the exact % I need to achieve. In this example column G2 is the target % of 67.201%. G2 = 67.201% (This is the target %) D4 = 4,250 (This is the number I need to increase to meet the percentage. The amount I need it to be is 4,681 for a difference of 431) As the percentage of G2...
  14. Z

    cell format

    hello, i would like to know if i can preserve excel cell format when using any lookup formula, i have a chart and want to view sales by quantity/value or percentage based on slicer selection. the method that i’m using currently allows me to view any of the above with 1 type of format not based...
  15. E

    VBV: How do I enter percentage formatting (e.g. 0.000%) as a string without Excel converting?

    We have a macro that reviews all the formatting of one spreadsheet against another spreadsheet. My problem: If spreadsheet "A" has a percentage formatting of 0.00% and spreadsheet "B" has a percentage formatting of 0.000%, when entering the results in a separate "Results" spreadsheet, Excel...
  16. B

    how to put in percentages in a pivot table?

    I've run a pivot table like I normally do. Is there a way to find out what percentage of total values each bucket is taking up? In the data below the total is 30 rows of information. So in C1 I'd like to see whatever percentage 5/30 is, in C2 I'd like to see 33% (10/30). Is there a way to...
  17. J

    Nested IF in Sliding Scale Formula

    Sorry. I know there is a simple solution to this and I’m just blind to it. Calculating Sliding Scale Percentage Current Formula in cell A46 =IF($B$33<5000,”.007”,IF($B$33<10000,”.006”,IF($B$33>9999,”.005”,””)))*10 This works perfect, however I need this formula to consider the value of A43...
  18. B


    Can someone assist in dividing a cell by all cells in range. Something like this. I have lr as follows: Dim lr As Long: lr = Range("B" & Rows.Count).End(xlUp).Row range("D2:D" & lr) = "C2/sum("C2:C" & lr)" Thank You
  19. M

    Percentage multiplication and subtraction

    Excel 2007 Col B and Col C contain numbers in numericals. I am calculating C24*75%, minus B7, minus B11, minus B15. For example C24=10000, B7=246, B11=543 and B15=688, then C24*75%= 7500-246-543-688 = Answer 6023. Kindly advise me formula. Thanks,
  20. B

    Change row colour for complete tasks

    I want to change the colour of the row to green when my 'project status' is inputted at 100%. Is there a way I can do this?

Some videos you may like

This Week's Hot Topics