Hi,

Is there a way to call for a maximum value, but for that value not to exceed
X? For example, MAX(A:A) where the largest value is 7200, but I would
specify that if the MAX value is over 7000, return 7000.

I could use a logical statement, but I was wondering if there was a
worksheet function that did it all in one without having to type out the
logic. (Don't mean to be lazy, but I have LOTS of them to do.)

Thanks in advance,
Jason