CY___ LY__ PCT CHG
$504 -$154 -445%
Here is an example where we obviously had a positive increase, but yet the Percent Change shows a negative. I am showing the formula being used to calculate the Pct Diff: =IF(ISERROR((A2-B2)/B2),"-",(A2-B2)/B2). Is there a formula to show the correct Positive Percent Change? I've been searching and searching and read many arguments about this, but no real solutions. Can you help?
Bookmarks