excel graphing

posted by .

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

Respond to this Question

First Name
School Subject
Your Answer

Similar Questions

  1. Computer Math

    Can anyone help me? Here's what I'm looking for: Col. A = Base period number Col. B = Given number this current period. NEEDED: Spreadsheet formula for: If B >= A, what is %?
  2. math

    round result to two decimal places...the answer i have is: 7.023 so two decimal places would it be: 702.0 You're asked to round to two decimal places. 7.023 = 7.02. Your answer has only one decimal place. so i guess my answer is wrong …
  3. 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 …
  4. 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 the …
  5. excel graphing

    In column F (cell ranges F5:F16), use an appropriate formula to calculate the percentage of the grand total for each type of office supply. Format the results in the Percentage style. If necessary, decrease the decimal places to round …
  6. Excel formula help

    Formula to multiply the number in cell 4k times standard deviation of the numbers in cell z2 through z10 I don't understand cell z2 through z10 I have never had excel (4kxz2xz10) Please write this correctly
  7. Calculus

    Let f be the function defined as follows. $ y = f(x) = \sqrt{{\color{red}3} x +{\color{red}10}}$ (a) Find the differential of f. dy = (b) Use your result from part (a) to find the approximate change in y if x changes from 4 to 4.1 …
  8. Calculus

    Let f be the function defined as follows. $ y = f(x) = {\color{red}5} x^2 -{\color{red}9} x +{\color{red}10} $ (a) Find the differential of f. dy = (b) Use your result from part (a) to find the approximate change in y if x changes …
  9. Calc

    I need help finding the correct formula after finding the doubling time and continuous percentage. I got the doubling time of 24 days and the continuous percentage of 2.89%. Homework asking use the doubling time to find the continuous …
  10. Statistics

    Please help, I do not understand how to do this: Let x be a random variable that represents white blood cell count per cubic milliliter of whole blood. Assume that x has a distribution that is approximately normal, with mean μ = 7400 …

More Similar Questions