In the previous post, we saw ‘Lookup & Reference | How to Use Excel HLKOOUP Function?, now we will learn about How to Use Excel ABS Function?’.
Where to Find the Math & Trig Function?
To find the Math & Trig function in excel open excel and click on the “Blank” to open a blank excel worksheet now click on the ‘Formula Tab’ and under ‘Function Library’ click on the ‘Math & Trig’ option as shown below:
You can also see the Math & Trig function via shortcut key – press ‘ALT + M + G’ after that select the Math & Trig function that you want to use.
What is Excel ABS Function?
The Excel ABS function returns the absolute value of a number. The absolute value of a number is the number without its sign.
Syntax
ABS(number)
Arguments
The ABS function syntax has the following arguments:
Number Required. The real number of which you want the absolute value.
Understand With Example
Also read the other articles:
If you want to make the lower case, The Excel LOWER function Converts all uppercase letters in a text string to lowercase. It ignores space, numbers, and punctuation. Visit this link – Excel LOWER Function.
The Excel PROPER function Capitalizes the first letter in a text string and any other letters in the text that follow any character other than a letter. It Converts all other letters to lowercase letters. Visit this link – Excel PROPER Function
Learn TallyPrime:
For Latest Updates & Learning Join Our YouTube Channel: Join Now
