Specify Maximum Value
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
|