I'm looking for a function in Excel that looks something like

```
= MAX(ABS(A1:A10))
```

except `ABS()`

doesn't take a range of numbers.

The best that I can come up with is:

```
= MAX(ABS(MIN(A1:A10)),ABS(MAX(A1:A10)))
```

It does the trick, but it's messy as all heck and I can't believe there's not a better way. Any ideas?