1. 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...
  2. 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...
  3. 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...
  4. 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.
  5. 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...
  6. 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...
  7. 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...
  8. 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
  9. 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...
  10. 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...
  11. 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...
  12. 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...
  13. 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...
  14. 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...
  15. 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
  16. 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,
  17. 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?
  18. C

    If statement maybe?

    I am working on a formula and I have a Name in A31, A percentage in M31, then I have a list of names in Column U. What i need is if that name in A31 is a member of the list in Column u and the percentage is over a set number return a yes. Any ideas?
  19. V

    Sumif based on percentage

    Hi, I need to add up one column if the percentage in another is below a certain percentage. I am able to use the formula =sumif(A1:A10,"<"& A12,B1:b10)*A12 Column B has percentages calculated cell A12 is the percentage (that changes every month) Because the percentage is not an even number say...
  20. M

    PowerBI: How to calculate/convert Time into Percentage using DAX/Measure

    Hi to all, I managed to get in Excel desired % of time difference from column E, easy job just changed the Data Type to Percentage. What are we calculating is % of these TimeDifferences, one per one (other columns inconsiderable). The calculation I used is: MOD(D3-D2;1) and Column F (%) is just...

Some videos you may like

This Week's Hot Topics