Here is an example using imbedded "IF" statements.


=IF((SUM(F5:F17)B11),B11,IF((SUM(F5:F17)<B9),B9,S UM(F5:F17)))

Assuming that (Sum(F5:F17)) is the field you are drawing from this wil
allow your contition and keep you within your perameters.

Hopefully it will help.

Goober

--
goobe
-----------------------------------------------------------------------
goober's Profile: http://www.excelforum.com/member.php...fo&userid=1983
View this thread: http://www.excelforum.com/showthread.php?threadid=39529