Heather

=MIN(1000,your_Formula)

Where 1000 is the maximum you want to evaluate as.

Mike

"hln" wrote:

I have a total dollar amount I have to stay under....not go over. I am
gathering the totals from multiple cells which is a percentage from another
number. is there a way to put like a cap on the total so it only calculates
upto a certain number? Im not sure how to explain this without looking at
it.
--
Heather