Question about Microsoft Excel for PC

# How do i calculate a difference in a percent?

I want to calculate the difference between two cells and have the result in the form of a percent

Posted by Anonymous on

### Scott

• Level 1:

An expert who has achieved level 1.

MVP:

An expert that gotÂ 5 achievements.

New Friend:

An expert that has 1 follower.

Hot-Shot:

An expert who has answered 20 questions.

• Contributor

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%.

Posted on Jul 16, 2014

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

×

my-video-file.mp4

×

## Related Questions:

### How do I enter percents without dividing or entering it as a non-percent decimal?

Your question really is How do I get a result without doing anything? I have no answer for that.

Oct 06, 2014 | Casio FX-270W Calculator

### Calculate percentage when my actual is less than mu budget

Assuming you want the result in the form :
a) 120% (if positive) or 80% (if not), then percent = Actual / Budget * 100
b) 20% (if positive) or -20% (if not), then percent = (Actual / Budget * 100) - 100

Nov 03, 2013 | Computers & Internet

This calculator can show the results in radical form if it involves square roots. The 4th root of 243 is 3 times the fourth root of 3, which unfortunately is beyond the calculator's capabilities to display in radical form. Try taking the fourth root of 3 (or equivalently, the square root of the square root of 3) and you'll see the calculator display the result in decimal.

Feb 06, 2013 | Casio Office Equipment & Supplies

The calculator can show the results in radical form if it involves square roots. The 4th root of 243 is 3 times the fourth root of 3, which unfortunately is beyond the calculator's capabilities to display in radical form. Try taking the fourth root of 3 (or equivalently, the square root of the square root of 3) and you'll see the calculator display the result in decimal.

Feb 06, 2013 | Office Equipment & Supplies

### How do u get % on it

On calculators you do not usually get percents. Instead, you get values which can be converted to a percent. For example what percent is 245 out of 987. You divide 245/987=.248. This is essentially the same as saying 24.8 percent. You move the decimal over 2 values. You can also round to get a nice percent number such as 25 percent.
If you are trying to put in a percent lets say you have to find 47% of 80. You just multiply .47 * 80= 38.4

Jun 14, 2011 | Texas Instruments TI-84 Plus Silver...

### 81 is what percent of 135

To find what percent of 135 is 81 take 81/135 = 0.6 This is only in decimal form so we times 0.6 by 100
to put it into percent. So 81 is 60% of 135.

Mar 31, 2011 | Texas Instruments TI-83 Plus Calculator

### The percent of 140 from 762.90 = ?

Sorry to say, soweeto54, but that question you've posted does not make much sense. It can be interpreted in three different ways, neither of which can be gleamed with much confidence. Yet I will still offer you three valid answers for your TI-83,

"The percent of 140 from 762.9 =". The troublesome part is the "from". Percents questions should be written in terms of "is" and "of".

TWO INTERPRETATIONS.

RESPONSE 1. The question could be read as "what percent of 762.9 is 140?". To do this on your calculator you simply do 140 divided by 762.9. From there, you simply move the decimal point two digits to the right to convert it into an equivalent percentage. So, that should be [1][4][0] [/] [7][6][2][.][9] [=] on your TI83. This was an example of a "percent of" question.

RESPONSE 2. The question could be read as "what percent of 140 is 762.9?" To have your TI83 calculate this you simply do 762.9 divided by 140. Of course, you will then need to move the decimal over two spots to the right in order to turn it into an equivalent percentage. Yes, it probably is strange to think of a number being more than 100 percent of another but it is a valid statement which occurs in the real world every single day. Nonetheless, for your TI83 you just press [7][6][2][.][9] [/] [1][4][0] [=]. This was another example of a "percent of" question. In fact, this is just the decimal reciprocal of the previous answer.

RESPONSE 3. The question could also be read as "140 from 762.9 will leave me with what percentage?" IE, 762.9 minus 140 will yield a number which is "x" percent of the original. Here, you would just do 762.9 minus 140, then you would take that answer and divide it by 762.9. From there, you'd do the old usual and move the decimal over two spots to the right for a percentage result. So, for your TI83 you'd do [(] [7][6][2][.][9] [-] [1][4][0] [)] [/] [7][6][2][.][9] [=]. Viola. This was an example of a "percent change" question. In fact, this is just the complement to response number one.

Mar 12, 2011 | Texas Instruments TI-83 Plus Calculator

### What are the RPN keystrokes for the following problem: 8%+.9(12.2-5.2)+3%

The problem as written is not well-formed. The leading "8%" does not say "8% of what", and the "+3%" is ambiguous, so I assume the problem really is (( x + 8%) + .9 ( 12.2 - 5.2 )) + 3%, where x is a number entered before.

The resulting RPN key sequence is:
1. x [ENTER] --- giving a value for the 8% to operate on
2. 8 [%] [+] --- add the 8% to the previous value
3. .9 [ENTER] --- push the 0.9 to the stack
4. 12.2 [ENTER] 5.2 [-] --- evaluate the content of the brace
5. [x] --- multiply .9
6. [+] -- add the x + 8% and .9 ( 12.2 - 5.2 ) terms
7. 3 [%] [+] --- add three percent to the result from step 6.
In case you actually meant ( x + 8% ) + ( .9 ( 12.2 - 5.2 ) + 3% ) - note the difference in the position of the braces:
1. x [ENTER] --- giving a value for the 8% to operate on
2. 8 [%] [+] --- add the 8% to the previous value
3. .9 [ENTER] --- push the 0.9 to the stack
4. 12.2 [ENTER] 5.2 [-] --- evaluate the content of the brace
5. [x] --- multiply .9
6. 3 [%] [+] --- add three percent to the result from step 5.
7. [+] -- add the x + 8% and .9 ( 12.2 - 5.2 ) + 3% terms.
Note, the only difference is the reversed order of step 6 and 7.

Jan 19, 2011 | HP 12c Calculator

### Where is the percent sign on this calculator

Sorry to disappoint you, but there is no such button or command on the TI8x family of calculators.
To convert from decimal ratio to percent value, move the decimal mark two places to the right.
To convert from percent to decimal value, move decimal mark two places to the left.

Nov 02, 2010 | Texas Instruments TI-83 Plus Calculator

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

## Open Questions:

#### Related Topics:

246 people viewed this question

Level 3 Expert

Level 3 Expert