Specify Maximum Value

[Guest]

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

 

[Bernard Liengme]

MIN(MAX(A:A),7000)

 

[Guest]

Wow!! That's awesome!! I had never thought of that! I guess that's sort of
like with logic, there's only 3 statements, right? Anyway, thanks for the
help!