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