I'm looking for a function in Excel that looks something like
ABS() doesn't take a range of numbers.
The best that I can come up with is:
It does the trick, but it's messy as all heck and I can't believe there's not a better way. Any ideas?