percentage format

  1. M

    Formula for percentage of principal payment

    holla guys, I want to make a formula for the percentage of principal payment items whose cumulative weight value is at least 80% (eighty percent) of the entire value of the work, calculated starting from the payment item with the largest weight value is there a formula I can use
  2. C

    percentage sum

    HELLO i want some help with excel. i have 4 cells that i want to fill with percentage and i want them to add up to 100% for example i have A1,A2,A3,A4 and i want to put a percentage like 25% in A1 and the rest cells would fill with 25% so the 4 cell add up to 100%. so for A1=25% then...
  3. J

    Formula that does not exceed 160%

    I am trying to create a formula that does not exceed 160% and 40% I am using cells E6 (Numerator) and G6 (Denominator). I would like E6/G6 to = 80% and it to not exceed 160%. I plan on using the percentage "number" option to add to the aesthetic appeal. In addition I would like to another that...
  4. K

    Get rid of the percent symbol or help with (#DIV/0!)

    Help....I have a column that is the sum of 2 other columns. I need it to list as a percentage, but without the percentage symbol. I used the formula of dividing one cell against the other than times it by 100. [ie. (A1/A2)*100], which works. However when the value is 0 (ie. 10/10) then I get...
  5. L

    Percent Format Not working Properly for Percents Less Than 1

    I have an input cell formatted as Number/Percentage/4. This cell needs to display the user's input without the user having to type the percent sign. It is used to express some small tax percentages, oftentimes less than 1%. This cell is used in other places on the sheet to perform calculations...
  6. G

    VBA Userform, multiplying number with percentage

    I'm designing a userform. I'm multyplying two textboxes together, one of the textboxes is a number and the other one is a percentage. First of all I had problems changing the format to a percentage. If there is an easier way to change the format that works that would be great as well. The code...

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