Posted by **kayla** on Tuesday, May 24, 2011 at 2:03pm.

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?

## 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...
- Excel formula help - Formula to multiply the number in cell 4k times standard ...
- math - Consider the following bivariate data. Point A B C D E F G H I J x 3 4 2 ...
- statistics - Consider the following bivariate data. Point A B C D E F G H I J x ...
- math help - Can some one help me with this one??? Consider the following ...
- statistics check - Consider the following bivariate data. Point A B C D E F G H ...
- Math - Excel - Hi, I need to write an Excel formula and I am trying to double ...
- Software - Excel - Hi, Im doing my maths coursework andI need to type in a ...

More Related Questions