I presume that you are wanting a more involved answer than =ABS(A1), but
your question is not detailed enough for me to know what you really want.

Jerry

Haplo wrote:

How can I use the ABS (absolute) function to return an absolute value for a
ranage of numbers that are both negative and positive?