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

MIN(MAX(A:A),7000)


--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"jcliquidtension" wrote in
message ...
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

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!

"Bernard Liengme" wrote:

MIN(MAX(A:A),7000)


--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"jcliquidtension" wrote in
message ...
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