Question about Computers & Internet

1 Answer

How to calculate the percentage using the excel

Posted by on

Ad

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that gotĀ 5 achievements.

    Governor:

    An expert whose answer gotĀ voted for 20 times.

    New Friend:

    An expert that has 1 follower.

  • Expert
  • 81 Answers


Hide All
Percentages are calculated by using the following equation:
amount/total = percentage
Where percentage is in decimal format.
What do you want to do?


Calculate the amount if you know the total and percentage For example, if you purchase a computer for $800 and there is an 8.9% sales tax, how much do you have to pay for the sales tax? In this example, you want to find 8.9% of 800.
Example The example may be easier to understand if you copy it to a blank worksheet.

  1. Create a blank workbook or worksheet.
  2. Select the example in the Help topic. Note Do not select the row or column headers.
    Selecting an example from Help
  3. Press CTRL+C.
  4. In the worksheet, select cell A1, and press CTRL+V.
  5. To switch between viewing the results and viewing the formulas that return the results, press CTRL+` (grave accent), or on the Formulas tab, in the Formula Auditing group, click the Show Formulas button.
1 2 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) Note To convert a number in percentage format to a decimal, divide it by 100. For example, the sales tax in this example (8.9) divided by 100 is .089.
Calculate the percentage if you know the total and amount For example, if you score 42 points correctly out of 50, what is the percentage of correct answers?
Example The example may be easier to understand if you copy it to a blank worksheet.
  1. Create a blank workbook or worksheet.
  2. Select the example in the Help topic. Note Do not select the row or column headers.
    Selecting an example from Help
  3. Press CTRL+C.
  4. In the worksheet, select cell A1, and press CTRL+V.
  5. To switch between viewing the results and viewing the formulas that return the results, press CTRL+` (grave accent), or on the Formulas tab, in the Formula Auditing group, click the Show Formulas button.



Simple way Amount/Total*100

Posted on Apr 30, 2011

Ad

1 Suggested Answer

Anonymous

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

Ad

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

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.
https://www.youtube.com/watch?v=UlD6vUKx2KE

Apr 08, 2017 | Excel Computers & Internet

2 Answers

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

2 Answers

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

1 Answer

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

1 Answer

Acer,Aspire 5720-4663 Math calculator: How does one use the percentage function?


Hi. Try this steps on using your math calculator for the percentage function.

Hope This Helps

Step 1. Note that not all calculators behave the same way as far as the percentage key is concerned. Thus, test the examples in this article on your calculator. If your calculator does not have the percent key or does not behave in the way described here, don't despair - you can still use it to calculate percentages, it's just that you will have to press a few more buttons.
Step 2. Let's calculate a tip on your restaurant bill. Suppose your bill happens to be $64.35 and you would like to leave 15% tip.
Type the following into your calculator: 64.35 * 15 %
Answer: 9.6525 or $9.65 after rounding.
Most simple calculators will give an answer right here without having to press the = sign. If yours does not, press = and see if you get the right answer.
Alternatively, you can calculate this percentage by typing in
64.35 * 15 / 100 or 64.35 * 0.15
Thus, you may have observed that all that the percent key did here was division by a hundred.
Step 3. Let's calculate a grade percentage - say you got 34 out of a maximum of 40 points.
To figure out your grade percentage type in: 34 / 40 %
Answer: 85
Alternatively, without the percent key: 34 / 40 * 100
Step 4. Let's calculate a sale price on those shoes that originally cost $139, but are now discounted by 35%.
On your calculator type in: 139 - 35 % =
Answer: 90.35 or $90.35
This calculation is amazingly easy with the percent key! Alternatively, you would first have to calculate what the 35% of the $139 is and then subtract it from 139:
139 * 35 / 100 = 48.65
139 - 48.65 = 90.35

Hope This Helps

May 30, 2010 | Computers & Internet

2 Answers

HOW TO CALCULATE PERCENTAGE IN MICROSOFT EXCEL?


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.

Feb 19, 2009 | Microsoft Computers & Internet

1 Answer

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

1 Answer

How to calculate the percentage


how to use the formula in the word excel

Jun 11, 2008 | Microsoft Computers & Internet

1 Answer

Percentage formula


Hi,

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

d770346.jpg

Good luck and kind regards.

Dec 09, 2007 | Computers & Internet

2 Answers

Excel


how to do substract in exccel

Oct 08, 2007 | Microsoft Office Standard for PC

Not finding what you are looking for?
Computers & Internet Logo

Related Topics:

802 people viewed this question

Ask a Question

Usually answered in minutes!

Top Computers & Internet Experts

Ekse

Level 3 Expert

13434 Answers

Marvin
Marvin

Level 3 Expert

85223 Answers

Brad Brown

Level 3 Expert

18165 Answers

Are you a Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...