What is the absolute value function in excel
- 藏色散人Original
- 2020-02-10 09:55:3537987browse
#What is the absolute value function in excel?
Function ABS that finds the absolute value.
Set the absolute value formula in excel
Method 1: Use the function ABS to find the absolute value, the formula is =ABS(A1).
Method 2: Let the number be compared with its negative number to find the absolute value. The formula is =MAX(A1,-A1), because any number is nothing more than a positive number , negative number, 0.
For more Excel-related technical articles, please visit the Excel Basic Tutorial column!
The above is the detailed content of What is the absolute value function in excel. For more information, please follow other related articles on the PHP Chinese website!
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：How to enter e raised to the power in excelNext article：How to enter e raised to the power in excel