Question about Microsoft Excel for PC

# IS THERE A PERCENTAGE FORMULA TO USE IN EXCEL

PERCENTAGE INCREASE AND DECREASE

Posted by on

### Julian Sammy

• Level 1:

An expert who has achieved level 1.

New Friend:

An expert that has 1 follower.

Corporal:

An expert that hasĀ over 10 points.

Mayor:

An expert whose answer gotĀ voted for 2 times.

• Contributor

There isn't a function for this, but the formula should be something like this:
A1: Number to increase / decrease
B1: % change
C1: 'INC' or 'DEC'
D1: =IF(C1='INC', A1+(A1*B1), A1-(A1-B1))

Posted on Jan 01, 2013

### 6ya staff

SOURCE:

Hi there,
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this issue over the phone in a minute or two.

Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.

Here's a link to this great service

Good luck!

Posted on Jan 02, 2017

### Anonymous

The formula is 200/700 equals the percentage;if you're in columns a, b, and c, the formula in c1 will look like:
=b1/a1.

Then you can format the cell to show the number (.2857) as a percentage (28.57%).

Posted on Jan 03, 2009

### Louie Role

SOURCE: percentage formula

Hi,

Since you are asking for the formula, it depends where your values are (cell). Please refer to the example below.

Good luck and kind regards.

Posted on Dec 09, 2007

### Anonymous

SOURCE: Percentages in Excel

No problem, Melinda, I am here to help!

A B C D
1 Question Yes No Total
2 Is sky blue? 20 2 22
3 Is world round? etc.

In this case, the formula for % of Yes would be: =B2/D2. This would give you a decimal point result such as 0.909091. Now if you want to make this look like a percentage in your spreadsheet, just do the following:
1) click on the cell where you have the division formula
2) clck on Format in the top menu bar
3) click on Cells
4) click on the Number tab (if you're not already there)
5) click on Percentage in the list of categories
6) click OK

To boil it all down to a simple principle, percentages are created in Excel by dividing the two numbers using a formula with "/" in it, and then formatting the result to look like a percentage instead of a decimal.

I might have misunderstood your question, and I have an idea of what else you might have been asking (and another slightly more complicated solution for it!), so please let me know if my first answer didn't hit the mark!

Good Luck!
Regards,
RichMTech

Posted on Aug 09, 2008

### Anonymous

SOURCE: excel formula for percentage

=A1 / A2

Posted on Feb 27, 2009

×

my-video-file.mp4

×

## Related Questions:

### I calculated percentage on excel using a formula but still it shows #value?. what do i have do to fix this? please help.

Right Click on cell with mouse and select format cells
then select number . If formula was for example percentage of cell a2 calculated from b2 calculated in c2 then in c2 you put =a2/b2
Then you can use percentage in the number format
or you can go =(a2/b2)*100
Also make the cell width more if a problem.

Apr 08, 2017 | Excel Computers & Internet

### What is formula to find percentage of females in my workplace?

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

### How to do percentages in Excel - Office Blogs

https://blogs.office.com/2011/08/02/how-to-do-percentages-in-excel/
Feedback

### How to Calculate Percentages in Excel

www.excelfunctions.net > Excel-Formulas
Two Percentage Calculation Types. Calculate a Percentage as a Proportion.Calculate Percentage Change. Displaying Percentages in Excel Cells ...

### Excel formula: Get percentage of total ' Exceljet

https://exceljet.net/formula/get-percentage-of-total
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%.

Jan 19, 2016 | Computers & Internet

### What is the percentage increase from \$170000. to \$180000

The formula for percentage increase is always:

A2 - A1
--------- x 100
A1

Where A1 is the old amount and A2 is the new amount.

In this case A1 is \$170 000 and A2 is \$180 000.

Putting it into the formula, we get

180 000 - 170 000
----------------------- x 100
170 000

Let me know if you have any questions.

Good luck.

Paul

Sep 10, 2015 | Office Equipment & Supplies

### What is the percentage increase if one cell is blank and the other is 383 in Microsoft Excel 2010?

That is an unsolveable question. You have to have a Non Zero Starting point in order to calculate a percentage of increase. Black is essentially 0. and no % increase of 0 will bring you anything but 0

Sep 08, 2014 | Microsoft Excel 2010

### How to create a formula for increase decrease percent in excel

If you have a number in Cell A2 (say 100), and you put the amount of percentage increase or decrease in Cell A3 (say -10%), then put this formula into Cell A4 to calculate the answer:
=A2*(1+A3) , which then shows as the answer (90).

Sep 05, 2014 | Microsoft Excel for PC

### Calculate percentage increase

Percentage change = (new value -old value)/old value * 100%
If result is positive it is an increase. If it is negative it is a decrease
Here
%increase=(500-5)/5*100=9900 %

Dec 07, 2013 | Office Equipment & Supplies

### FORMULA FOR FINDING PERCENTAGE

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>

Apr 16, 2009 | Computers & Internet

### How to add % (Percentage column ) in the excel

The formula is 200/700 equals the percentage;if you're in columns a, b, and c, the formula in c1 will look like:
=b1/a1.

Then you can format the cell to show the number (.2857) as a percentage (28.57%).

Jan 03, 2009 | Microsoft Computers & Internet

### Percentages in Excel

No problem, Melinda, I am here to help!

A B C D
1 Question Yes No Total
2 Is sky blue? 20 2 22
3 Is world round? etc.

In this case, the formula for % of Yes would be: =B2/D2. This would give you a decimal point result such as 0.909091. Now if you want to make this look like a percentage in your spreadsheet, just do the following:
1) click on the cell where you have the division formula
2) clck on Format in the top menu bar
3) click on Cells
4) click on the Number tab (if you're not already there)
5) click on Percentage in the list of categories
6) click OK

To boil it all down to a simple principle, percentages are created in Excel by dividing the two numbers using a formula with "/" in it, and then formatting the result to look like a percentage instead of a decimal.

I might have misunderstood your question, and I have an idea of what else you might have been asking (and another slightly more complicated solution for it!), so please let me know if my first answer didn't hit the mark!

Good Luck!
Regards,
RichMTech

Aug 08, 2008 | Microsoft Excel for PC

### Percentage formula

Hi,

Since you are asking for the formula, it depends where your values are (cell). Please refer to the example below.

Good luck and kind regards.

Dec 09, 2007 | Computers & Internet

## Open Questions:

#### Related Topics:

511 people viewed this question

Level 3 Expert

Level 3 Expert