excel graphing
posted by kayla .
In cell D21, type the formula to calculate the % change from
January to February. That formula is: =(J18E18)/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.46521.07)/abs(521.07)

What is wrong with the Round function?
Round(100*((j18e18)/ABS(E18)),0) 
im still confused what would abs be?
Respond to this Question
Similar Questions

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 %? 
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 … 
excel graphing
In cell D21, type the formula to calculate the % change from January to February. That formula is: =(J18E18)/ABS(E18). Format the result in the Percentage style and decrease the decimal places if necessary to round the result to the … 
please help
In cell D21, type the formula to calculate the % change from January to February. That formula is: =(J18E18)/ABS(E18). Format the result in the Percentage style and decrease the decimal places if necessary to round the result to the … 
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 … 
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 
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 … 
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 … 
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 … 
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 …