ABS function

Words
194
Reading
1 min
Listen
Play
4y

ABS Function


Function Type:

Math and Trigonometry


Description:

ABS function returns the absolute (positive) value of a number.
If you only want the positive or magnitude of the number, this is the function you are looking for.


Function Structure:

=ABS(number)


Argument Breakdown:

number - The number to get the absolute value of.


Example:

ABSolute of a negative

ABS function will return the positive number of a negative.

ABS function on a negative number formula

result:

ABS function on a negative number result


ABSolute of a zero 0

ABS function of a zero formula

result:

ABS function of a zero result

ABSolute of a positive

ABS function on a positive number formula

result:

ABS function on a positive number result


Still need help with Excel and Google Sheets?

Get Instant Expert Help in Fiverr or PeoplePerHour platforms. Click one icon below.

Get Instant Expert Help on Fiverr

Get Instant Expert Help in PeoplePerHour

We can also accept LEO, HIVE, HBD tokens as payment if we transact directly here in HIVE network.


This post is designated as a reviewer for Excel trainings I conduct.

Feel free to share with anyone. 馃槈

Earnings from Upvotes on this post are used to continue sharing Excel knowledge.
If you also want to earn HIVE in 7 days while blogging your favorite topics, join us here at Peakd.
*Thumbnail used is made in Canva