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.