Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating Max & Min in a negative numbes
i Have a worksheet with these number, when i select maximum from this list
below it give -40.34, i want to -55.25 as maximum and the same for Minimum, how to get with the formula, can anyone pl help. -48.94 -53.39 -54.54 -55.25 -49.52 -40.34 Max -40.34 Min -55.25 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating Max & Min in a negative numbes
=MAX(ABS(A1:A6))
HIH |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating Max & Min in a negative numbes
=MAX(ABS(A1:A6))
=MIN(ABS(A1:A6)) Both of which must be array entered with Ctrl+Shift+Enter Mike "srpavar" wrote: i Have a worksheet with these number, when i select maximum from this list below it give -40.34, i want to -55.25 as maximum and the same for Minimum, how to get with the formula, can anyone pl help. -48.94 -53.39 -54.54 -55.25 -49.52 -40.34 Max -40.34 Min -55.25 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating Max & Min in a negative numbes
Max: =MAX(ABS(A1:A6)) as an array formula confirmed with Ctrl+Shift+Enter
Min: =MIN(A1:A6) as a normal formula Regards, Stefi €˛srpavar€¯ ezt Ć*rta: i Have a worksheet with these number, when i select maximum from this list below it give -40.34, i want to -55.25 as maximum and the same for Minimum, how to get with the formula, can anyone pl help. -48.94 -53.39 -54.54 -55.25 -49.52 -40.34 Max -40.34 Min -55.25 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating Max & Min in a negative numbes
That changes the number to absolute so use this instead
=MIN(ABS(A1:A6))*-1 =MAX(ABS(A1:A6))*-1 Once again array entered Mike "Mike H" wrote: =MAX(ABS(A1:A6)) =MIN(ABS(A1:A6)) Both of which must be array entered with Ctrl+Shift+Enter Mike "srpavar" wrote: i Have a worksheet with these number, when i select maximum from this list below it give -40.34, i want to -55.25 as maximum and the same for Minimum, how to get with the formula, can anyone pl help. -48.94 -53.39 -54.54 -55.25 -49.52 -40.34 Max -40.34 Min -55.25 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating Max & Min in a negative numbes
On Jun 30, 4:08 am, srpavar wrote:
i Have a worksheet with these number, when i select maximum from this list below it give -40.34, i want to -55.25 as maximum and the same for Minimum, how to get with the formula, can anyone pl help. -48.94 -53.39 -54.54 -55.25 -49.52 -40.34 Max -40.34 Min -55.25 Nobody else asked. Why do you want a simple MIN and MAX to be the same? That has got to be incorrect no matter what field you are in. If you want to reverse them to show the ABS of the number as MIN/MAX, then Mike's formulas are good. But they shouldn't be the same. |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating Max & Min in a negative numbes
On Jun 30, 2:33*am, Mike H wrote:
That changes the number to absolute so use this instead =MIN(ABS(A1:A6))*-1 =MAX(ABS(A1:A6))*-1 Once again array entered That presumes that you know you want a negative result. If that's the case, you might as well simply reverse MIN and MAX. That is, for negative numbers, the "largest" number (magnitude) is simply MIN(A1:A6), and the "smallest" number (magnitude) is MAX(A1:A6). No array-entry required. What you might have had in mind was something like the following (committed with ctrl-shift-Enter): =min(abs(A1:A6))*sign(A1) =max(abs(A1:A6))*sign(A1) That persumes that all the signs of A1:A6 are the same, so it does no matter which one we look at. Of course, the OP's question makes little sense if we don't make this assumption in the first place. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating growth with negative numbers | Excel Worksheet Functions | |||
Calculating and posting when a qty will go negative. | Excel Worksheet Functions | |||
How do you use the < funjctions when calculating negative numbe | Excel Worksheet Functions | |||
calculating positive and negative formulas | Excel Worksheet Functions | |||
Calculating negative time. | Excel Discussion (Misc queries) |