percentage

  1. 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...
  2. 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...
  3. B

    Percentage

    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
  4. 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,
  5. 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?
  6. 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?
  7. 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...
  8. 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...
  9. R

    Traffic light warning system

    Hi Hoping someone here can help me... I have a SS which has an income cell and then an expenses cell... In a new cell which looks at the expenses and shows what percentage of the income is now covered by expenses and gives the percentage figure and then like a traffic lights system, green from...
  10. N

    Formula for Calculating Percentage through the year

    Hi, I'm trying to come up with a formula that calculates how far we are through the year in percentage. Right now I have: =YEARFRAC(DATE(YEAR(TODAY()),1,1),TODAY()) But I'm not sure it's working properly. Any ideas? Thanks, Mark
  11. H

    Percentage Question

    Hello, I am trying to calculate the percentage of non-contiguous cells that contain the letter "a" out of all the selected non-contiguous cell. I am new to this site and am unsure how to upload reference images. I shall try to explain this as best i can. The target cell is Q2. i want to be able...
  12. A

    Win/Loss Percent on visible rows

    This code displays my Win/Loss Percentage. I'm using an auto-filter macro to filter data and I would like to show my Win/Loss percentage on visible rows only. Can someone assist. Thank you kindly. With WorksheetFunction CCI = Format(.CountIf(Range("P18:P" & LRow), ">" &...
  13. L

    Percentage total in Spreadsheet counting Yes and NA as a percentage total

    Hello I want to make a simple table that counts "Yes" and "NA" as a positive and gives me a percentage total. For example if I had a list of 10 cells and I had 8 Yes, 1 NA and 1 No I want it to give me a result of 90% I have played around with formulas and can get this =COUNTIF(A4:A13...
  14. muhammad susanto

    Data Lookup With 3 Criteria Number (Positive,Negative & Zero) Percentage

    hi all.. i have a problem to data lookup with 3 criteria number (positive percentage number,negative percentage number,zero number) for easy to understand maybe like below layout table : <style type="text/css"> table.tableizer-table { font-size: 12px; border: 1px solid #CCC...
  15. F

    Convert Userform textbox to percentage

    I have a userform with two textboxes that receive a number from a spreadsheet when double clicked. The numbers on the spreadsheet are percentages so I've formatted the textboxes to show the percentage. The code below works fine. I would now like to add those two textboxes together in another...
  16. D

    Dividing fractions into new cell

    I am looking for a way to divide a fraction in one cell and put the percentage of that fraction into the next cell. Example: B2- 36/164 C2- Percentage from B2 (36/164 = 21.95%) Any help is greatly appreciated. Thanks.
  17. redspanna

    show percentage formula result as a general number

    Hi all In cell AG9 I have a simple formula to work out a percentage value from two numbers in other cells. so cell AG9 holds the formula =K14/500 and then cell AG9 if formatted as a PERCENTAGE, the result showing (with no decimal points) as 10 is there a formula to then show this result as a...
  18. H

    help in cumulative percentage

    How To Set deduction cumulative percentage from 01/08 to 30/08 If employee late in arrival more than day and finish this work If attendance in 02/08 is 08:30 is deduction is 10% And attendances 03/08 09:15 deduction is 30% need to be 10 + 30 = 40% and do that for all month date...
  19. S

    How to calculate expenses in a dynamic cash

    I have 4 columns for each partner. Contribution Expenses Balance %Balance In the second column (Expenses) I see the expenses that are being made and that should be divided among those people who have a contribution percentage (see the last column), and each one will spend based on that...
  20. M

    I think it's an IF formula.... but I can't get it to work

    Hi all - really hoping an Excel genius can work this one out for me :cool: Scenario is: I want to review the safety stock levels of a number of components. I've taken 2 components as an example If the percentage adherence to the agreed safety level, over a period of time, falls below a...

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