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

Respond to this Question

First Name

Your Response

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