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

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

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