This sounds like something that could be handled by the MIN() and MAX()
formulas. You would just add it to your existing formula as such...

=MAX(0,existing formula)
=MAX(-100%, existing formula)


--
Lotus123
------------------------------------------------------------------------
Lotus123's Profile: http://www.excelforum.com/member.php...o&userid=28611
View this thread: http://www.excelforum.com/showthread...hreadid=498390