Thanks, it did help albeit indirectly.

After a few trials and errors juggling it about I decided to do the SUM
in a seperate equasion and ended up with this which worked:

=IF(M6<=0,0,M6)

Thanks again
:)
Tan.


--
Tan.
------------------------------------------------------------------------
Tan.'s Profile: http://www.excelforum.com/member.php...o&userid=30616
View this thread: http://www.excelforum.com/showthread...hreadid=502666