Asked by kayla
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)
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)
Answers
Answered by
bobpursley
What is wrong with the Round function?
Round(100*((j18-e18)/ABS(E18)),0)
Round(100*((j18-e18)/ABS(E18)),0)
Answered by
kayla
im still confused what would abs be?
There are no AI answers yet. The ability to request AI answers is coming soon!
Submit Your Answer
We prioritize human answers over AI answers.
If you are human, and you can answer this question, please submit your answer.