Question about Microsoft Computers & Internet

# HOW TO CALCULATE PERCENTAGE IN MICROSOFT EXCEL?

Posted by on

• Level 2:

An expert who has achieved level 2 by getting 100 points

New Friend:

An expert that has 1 follower.

Night Owl:

An expert who has answered 10 or more questions between 12 midnight and 6am on the same day.

Hot-Shot:

An expert who has answered 20 questions.

• Expert

Quantity / total * 100.0 = percentage. You can enter the quantity and the total in different cells and then use a third cell for the calculation (such as =A1/A2*100.0) or enter data in a single cell (such as =250/1000*100.0).

Posted on Sep 15, 2014

• Level 3:

An expert who has achieved level 3 by getting 1000 points

All-Star:

An expert that got 10 achievements.

MVP:

An expert that got 5 achievements.

Vice President:

An expert whose answer got voted for 100 times.

• Master

Hi nastyguy3000;

To calculate a percentage in excel you simply take
amount/total = percentage in your cell

Example A B Purchase price Sales tax (in decimal form) 800 0.089 Formula Description (Result) =A2*B2 Multiplies 800 by 0.089 to find the amount of sales tax to pay (\$71.20)

Have Fun

Mark

Don't forget to leave a rating.

Posted on Feb 19, 2009

• Mark Taylor Feb 19, 2009

Here's a better diagram

Mfark

×

Hi,
a 6ya expert can help you resolve that 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.
the service is completely free and covers almost anything you can think of.(from cars to computers, handyman, and even drones)
Goodluck!

Posted on Jan 02, 2017

×

my-video-file.mp4

×

## Related Questions:

### 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 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

### How do i calculate a difference in a percent?

If the value in A1 is 100, and the value of A2 is 120, then the formula =(A2/A1)-1 will return 0.2. If the cell containing the formula is then formatted to display as percentage it will show as 20%.

Dec 13, 2013 | Microsoft Excel for PC

### 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

### Should I use countif or if or what ??

hi this my id :dadu_mf@rediff.com plz send excel material

Mar 25, 2008 | Microsoft Excel for PC

## Open Questions:

#### Related Topics:

2,845 people viewed this question

Level 3 Expert

Level 3 Expert