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.
- Create a blank workbook or worksheet.
- Select the example in the Help topic.
Note Do not select the row or column headers.
Selecting an example from Help
- Press CTRL+C.
- In the worksheet, select cell A1, and press CTRL+V.
- 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.
- Create a blank workbook or worksheet.
- Select the example in the Help topic.
Note Do not select the row or column headers.
Selecting an example from Help
- Press CTRL+C.
- In the worksheet, select cell A1, and press CTRL+V.
- 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
this calculator is ****. it cant even perform a basic percentage calculation like a normal calculator.
The fact I have to come on here to look up solutions for a basic calculator says it all really...
Guest's Sept 27 entry works for me. But why should we have to do that? I blame Bill Gates.....
im not sure what you could maybe type in l/z that normally works
gives incorrect percentage
×