Shulou(Shulou.com)06/01 Report--

This article mainly explains "what is the function of ABS function". The content of the explanation is simple and clear, and it is easy to learn and understand. Please follow the editor's train of thought to study and learn "what is the role of ABS function".

Function: returns the absolute value of the parameter.

Syntax: ABS (num)

Note: the parameter num represents a numerical value or a referenced cell that requires an absolute value. The parameter must be numeric, not a character. For example, if the B2 cell is the character A, then ABS (B2) returns the error value "# VALUE!".

Example:

C4 cell formula = IF (B3 > B4, "decrease", "increase") & ABS (B3-B4) & "kg"

When calculating the increase or decrease of weight in the case, ABS (B3-B4) is used to take the absolute value of the calculation results to avoid the increase of-1kg. The ABS function is relatively simple, as long as you keep in mind that the argument must be numeric.

Thank you for your reading, these are the contents of "what is the function of ABS function". After the study of this article, I believe you have a deeper understanding of what the role of ABS function is, and the specific use needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.