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

Ad

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

Ad

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

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

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

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

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

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

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.

to put it into percent. So 81 is 60% of 135.

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

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.

"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

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:

The resulting RPN key sequence is:

- x [ENTER] --- giving a value for the 8% to operate on
- 8 [%] [+] --- add the 8% to the previous value
- .9 [ENTER] --- push the 0.9 to the stack
- 12.2 [ENTER] 5.2 [-] --- evaluate the content of the brace
- [x] --- multiply .9
- [+] -- add the x + 8% and .9 ( 12.2 - 5.2 ) terms
- 3 [%] [+] --- add three percent to the result from step 6.

- x [ENTER] --- giving a value for the 8% to operate on
- 8 [%] [+] --- add the 8% to the previous value
- .9 [ENTER] --- push the 0.9 to the stack
- 12.2 [ENTER] 5.2 [-] --- evaluate the content of the brace
- [x] --- multiply .9
- 3 [%] [+] --- add three percent to the result from step 5.
- [+] -- add the x + 8% and .9 ( 12.2 - 5.2 ) + 3% terms.

Jan 19, 2011 | HP 12c 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.

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

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.

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

Jan 28, 2016 | Microsoft Excel for PC

Dec 12, 2013 | Microsoft Excel for PC

246 people viewed this question

Usually answered in minutes!

×