Question about Microsoft Excel 2010

Ad

If field A1 is the old value and A2 is the new value, then the formula for A3 (% change) is:=(A2-A1)/A1*100You can remove the *100 if you want to format the field to the Percent type.

Posted on Oct 11, 2011

Ad

If result is positive it is an increase, Otherwise it is a decrease.

May 02, 2014 | Casio ClassPad 300 Calculator

Mar 28, 2014 | Office Equipment & Supplies

Percent change =change*100 %

change=(8900.00-8640.00)/8640.00=0.0301

Percent change=0.0301*100%=3.01%

Since the change is positive, the new value is higher than the old value, this change is an increase.

Mar 05, 2014 | Office Equipment & Supplies

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

Assuming that the Original Value is in cell A1, and the New Value is in cell B1, then the formula for % Change pin Value is =(B1/A1)-1.Format the value in % style and you're done.Rgds,Scott

Sep 30, 2011 | Microsoft Excel for PC

Inputting a value and pressing SHIFT [%] converts the input value to a percent. For example:

2 SHIFT [%] = produces .02

To determine 20% of 150:

150 * 20 SHIFT [%] = produces 30

To calculate what percentage of 880 is 660:

660 / 880 SHIFT [%] = produces 75

To increase 2500 by 15%:

2500 + 2500*15 SHIFT [%] = or

2500 * (1+15 SHIFT [%] ) = produces 2875

To discount 3500 by 25%:

3500 - 3500 * SHIFT [%] = or

3500 * (1-15 SHIFT [%]) = produces 2625

To calculate the percentage change from 40 to 46:

(46 - 40) / 40 SHIFT [%] produces 15

2 SHIFT [%] = produces .02

To determine 20% of 150:

150 * 20 SHIFT [%] = produces 30

To calculate what percentage of 880 is 660:

660 / 880 SHIFT [%] = produces 75

To increase 2500 by 15%:

2500 + 2500*15 SHIFT [%] = or

2500 * (1+15 SHIFT [%] ) = produces 2875

To discount 3500 by 25%:

3500 - 3500 * SHIFT [%] = or

3500 * (1-15 SHIFT [%]) = produces 2625

To calculate the percentage change from 40 to 46:

(46 - 40) / 40 SHIFT [%] produces 15

Sep 11, 2010 | Casio FX-115ES Scientific Calculator

Hello this is Baris,

If you forget about the numbers and start naming your cells you can figure out your own formulas... Example :)

You buy apples, and you pay $2 per piece

in this case you have 2 numbers to find out how much you will pay.

price per apple

quantity

you have 3 apples you pay 6 dollars very simple right. 2 times 3.

Same thing in excel but this time you will just say price times quantity and excel will do the calculation for you.

Lets name your cells

Type in A1 Price

Type in B1 Quantity

Type in C1 Cost

Now, Column C is your calculation area.

Type in A2 2 (price for apples)

Type in B2 3 (quantity of apples)

Type in C2 =A2*C2 (price times quantity)

Now on, you don't have to calculate anything. You can change you price and quantity, cost will change by itself. Because the value in that cell is now related to other values in A2 and B2. I hope this gives you a starting point.

If you forget about the numbers and start naming your cells you can figure out your own formulas... Example :)

You buy apples, and you pay $2 per piece

in this case you have 2 numbers to find out how much you will pay.

price per apple

quantity

you have 3 apples you pay 6 dollars very simple right. 2 times 3.

Same thing in excel but this time you will just say price times quantity and excel will do the calculation for you.

Lets name your cells

Type in A1 Price

Type in B1 Quantity

Type in C1 Cost

Now, Column C is your calculation area.

Type in A2 2 (price for apples)

Type in B2 3 (quantity of apples)

Type in C2 =A2*C2 (price times quantity)

Now on, you don't have to calculate anything. You can change you price and quantity, cost will change by itself. Because the value in that cell is now related to other values in A2 and B2. I hope this gives you a starting point.

Sep 30, 2009 | Microsoft Excel for PC

Hello this is Baris,

First off all when you say hypotinuse I think it is a 90 Degree triangle. Total of the angles off a triangle is 180 degree. So it is a simple algebra question.

Hypotinuse is 90

Right angle is R

Left angle is L

Total is 180

Equation is 90+ R +L = 180

We are looking for R, so lets arrange our equation.

R= 180 - 90 - L

R= 90 - L

This is our formula for excel

Lets put it in the excel

Type in A1 "hypotinuse "

Type in A2 "Left Angle"

Type in A3 "Right Angle"

Type in B1 90

Type in B2 "whatever the value given for the left angle"

Type in B3 =90-B2

As soon as you change the value in the cell B2, B3 will change by itself. Hope this helps :)

First off all when you say hypotinuse I think it is a 90 Degree triangle. Total of the angles off a triangle is 180 degree. So it is a simple algebra question.

Hypotinuse is 90

Right angle is R

Left angle is L

Total is 180

Equation is 90+ R +L = 180

We are looking for R, so lets arrange our equation.

R= 180 - 90 - L

R= 90 - L

This is our formula for excel

Lets put it in the excel

Type in A1 "hypotinuse "

Type in A2 "Left Angle"

Type in A3 "Right Angle"

Type in B1 90

Type in B2 "whatever the value given for the left angle"

Type in B3 =90-B2

As soon as you change the value in the cell B2, B3 will change by itself. Hope this helps :)

Sep 27, 2009 | Microsoft Excel for PC

Is there by any chance a space or any other character before the equals sign? That could cause your formula to display as text.

Dec 03, 2007 | Microsoft Excel for PC

Aug 06, 2015 | Microsoft Excel 2010

581 views

Usually answered in minutes!

×