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

1. 👍 0
2. 👎 0
3. 👁 41

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

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

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