Hi,

I have a very long list laid out in the following manner,

Item 1~~Item 2~~Difference
3.5~~~~3.5~~~~0
4.2~~~~3.7~~~~0.5
-5~~~~-5~~~~~0

I need to see if the difference is more than 1% of the original value
in list 1.
I can work this out for the positive numbers, but when I copy the
formula through cells it doesnt work on negative numbers.

=(A2038*0.01)=(C2038)

Any ideas on how I can ignore the sign of the numbers in order to
ensure I get correct results?

Thanks in advance.


--
steev_jd
------------------------------------------------------------------------
steev_jd's Profile: http://www.excelforum.com/member.php...o&userid=33107
View this thread: http://www.excelforum.com/showthread...hreadid=533659