# excel graphing

In cell D21, type the formula to calculate the % change from
January to February. That formula is: =(J18-E18)/ABS(E18).
Format the result in the Percentage style and decrease the
decimal places if necessary to round the result to the nearest
whole percent

(569.46-521.07)/abs(521.07)

excel graphing - bobpursley, Tuesday, May 24, 2011 at 4:33pm
What is wrong with the Round function?

Round(100*((j18-e18)/ABS(E18)),0)

excel graphing - kayla, Wednesday, May 25, 2011 at 9:02am
im still confused what would abs be?
can someone please help

1. 👍 0
2. 👎 0
3. 👁 41
asked by kayla

## Similar Questions

1. ### excel graphing

In cell D21, type the formula to calculate the % change from January to February. That formula is: =(J18-E18)/ABS(E18). Format the result in the Percentage style and decrease the decimal places if necessary to round the result to

asked by kayla on May 24, 2011
2. ### please help

In cell D21, type the formula to calculate the % change from January to February. That formula is: =(J18-E18)/ABS(E18). Format the result in the Percentage style and decrease the decimal places if necessary to round the result to

asked by kayla on May 26, 2011
3. ### algebra/pre-calc - please help

Lines can be used to approximate a wide variety of functions; often a function can be described using many lines. If a stock price goes from \$10 to \$12 from January 1st to January 31, and from \$12 to \$9 from February 1st to

asked by melissa on November 19, 2016
4. ### Algebra

Lines can be used to approximate a wide variety of functions; often a function can be described using many lines. If a stock price goes from \$10 to \$12 from January 1st to January 31, and from \$12 to \$9 from February 1st to

asked by melissa on November 19, 2016
5. ### accounting

Your company manufactures specialty items. In order to reduce any loss from a customer canceling an order after production has been started, your company requests a 50% deposit before it will start the manufacturing process. On

asked by Deb on November 10, 2011
6. ### biology

need help few questions 1. a signaling cell produces a signal that is detected by what type of cell? 2. If the interior of a typical cell is negatively charged, what type of charged ions will not require energy to diffuse into the

asked by ava on November 11, 2014
7. ### science

need help few questions 1. a signaling cell produces a signal that is detected by what type of cell? 2. If the interior of a typical cell is negatively charged, what type of charged ions will not require energy to diffuse into the

asked by ava on November 12, 2014
8. ### science

need help few questions 1. a signaling cell produces a signal that is detected by what type of cell? 2. If the interior of a typical cell is negatively charged, what type of charged ions will not require energy to diffuse into the

asked by ava on November 11, 2014
9. ### Computer Science

w w w (dot)cs(dot)umass(dot)edu(slash)~verts(slash)coins105(slash)quizzes(slash)images(slash)hw10(dot)gif Using the constants in cells A2:A9, create formulae for cells A12:A15 (surrounded by a dark line) to compute the

asked by Andy on April 4, 2010
10. ### Math

Consider the following spreadsheet: What formula would you use to calculate the number in cell B2? Cell A Cell B Cell C Cost of item 4% tax cost of before tax item with tax \$130 5.2 \$135.2 \$150 6 \$156 I do not know how to write a

asked by BWB HELP on April 16, 2010

More Similar Questions