- If you need clarification, ask it in the comment box above.
- Better answers use proper spelling and grammar.
- Provide details, support with references or personal experience.
Tell us some more! Your answer needs to include more details to help people.You can't post answers that contain an email address.Please enter a valid email address.The email address entered is already associated to an account.Login to postPlease use English characters only.
Tip: The max point reward for answering a question is 15.
To get around this, you can calculate your numbers as percentages first. For example, if you type the formula =10/100 in cell A2, Excel will display the result as 0.1. If you then format that decimal as a percentage, the number will be displayed as 10%, as you 'd expect.Aug 2, 2011
Excel simply divides the values in column C by the total in C11. For the formula shown, the result is the decimal number .63. Because the Percentage number format is applied to cell E6, Excel displays .63 as 63%.
26=A (the A is the percentage of the this year)
so we make 26*100=3*A
A=2600/3=866.67 (is the percentage of the this year)
and to know the percentage increase (we remove the percentage of the last year (100%) from the percentage of the this year 866.67%
so we get 866.67-100=766.67
so your percentage increase is 766.67%
i wish it helps
What do you mean by 'set' a percentage key. Is there a percentage key on the keyboard already? are you trying to set a rate?
If you want to use it for discounting, you just type an amount to discount in REG mode and press %- to remove it.
Please describe your use and I'll try to help
find "fx" on your toolbar; choose all formulas find percentage, you can set a specific percentage to the cell, just put the number you want a percentage of or if you want to keep that number, put the percentage formula in the next cell <%a:2>