Homework Help: excel graphing

Posted by kayla on Wednesday, May 25, 2011 at 1:19pm.

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

No one has answered this question yet.

Answer this Question

Related Questions

excel graphing - In cell D21, type the formula to calculate the % change from ...
please help - In cell D21, type the formula to calculate the % change from ...
excel graphing - In column F (cell ranges F5:F16), use an appropriate formula to...
Software - Excel - Hi, Im doing my maths coursework andI need to type in a ...
Math - Consider the following spreadsheet: What formula would you use to ...
Math - Consider the following spreadsheet: What formula would you use to ...
Data Analysis Help - Arithmetic operations, cell references, and __________ can ...
excell graphing - what formula should i use to calculate the total cost of cell ...
Excel - How would you write a formula to divide the number in the cell v45 by ...
Excel computers - How would you write a formula to multiply the number in cell ...

For Further Reading

First Name:
School Subject:
Answer: