Dear Lotus,

Thanks very much for your input. I knew there ought to be some simple
solution, but you can spend many frustrating hours trying to find the answers
to such questions when you don't know.

Please accept my thanks and best wishes.

"Lotus123" wrote:


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