Thanks for the tip but shouldn't the forumula be multiplied by 100? Viz.
=100*(A2-B2)/(A2*-SIGN(A2))
to get
-4, 5, 225%
-4, -5, -25%
-4, -3, 25%
4, 5, 25%
4, -5, -225%
Thanks for the tip but shouldn't the forumula be multiplied by 100? Viz.
=100*(A2-B2)/(A2*-SIGN(A2))
to get
-4, 5, 225%
-4, -5, -25%
-4, -3, 25%
4, 5, 25%
4, -5, -225%
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks