Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What is the maximum text size in a cell | Excel Discussion (Misc queries) | |||
How can I extend the maximum # of columns to 500 | Setting up and Configuration of Excel | |||
maximum size of a Microsoft Excel list for a pivot table | Excel Discussion (Misc queries) | |||
Maximum File Size | Excel Discussion (Misc queries) | |||
Cell value as chart scale maximum | Charts and Charting in Excel |