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
Sure! I can help explain.
In this context, ABS stands for the "absolute value" function. The ABS function in Excel returns the absolute value of a number, which means it returns the positive value of a number regardless of its sign.
In the formula you provided, ABS(E18) is used to calculate the absolute value of the value in cell E18. This is done to avoid a negative percentage result, as the absolute value ensures that the denominator of the equation is always positive.
To calculate the percentage change from January to February in cell D21 using the given formula, you can follow these steps:
1. Type the formula: In cell D21, enter the formula =(J18-E18)/ABS(E18).
2. Format as percentage: Select cell D21, then go to the Home tab in the Excel ribbon. In the Number group, click the "%". This will format the result as a percentage.
3. Adjust decimal places: If necessary, you can round the result to the nearest whole percent by following the steps below:
a. Right-click on cell D21 and select "Format Cells" from the context menu.
b. In the Format Cells dialog box, select "Percentage" from the Category list.
c. In the Decimal places field, specify the number of decimal places you want. To round to the nearest whole percent, you can set it to 0.
d. Click OK to apply the changes.
After following these steps, cell D21 will display the calculated percentage change from January to February, rounded to the nearest whole percent.