On Apr 3, 11:48*pm, Gary''s Student
wrote:
Probably just a formatting issue. *Select the cell with the formula and:

Format Cells... Number Percentage
--
Gary''s Student - gsnu200777

Hi,

I believe percent difference is different to percent change. Assuming
C5 is your new value, and B5 is the old value, percent change should
just be =(C5-B5)/C5 like you have. Not sure why you are using the
absolute value of B5, but since I have never seen a stock price below
zero, I guess it doesn't matter... if someone sees one, I'll buy 'em
all! :)

On the other hand, percent difference would be =ABS(C5-B5)/
AVERAGE(C5,B5). This will give the difference between the two numbers
expressed as a percentage of the average and is representative of how
similar the values are.

In summary, there shouldn't be anything wrong with your formula...
just check your source cells (make sure B5 doesn't equal zero) and the
formatting as Gary"s Student suggests.

Cheers,
Ivan.