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.