Skip to content
xlsoffice. All Rights Reserved
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Lookup and Reference Examples

  • How to get address of first cell in range in Excel
  • How to use Excel COLUMN Function
  • Create hyperlink with VLOOKUP in Excel
  • INDEX function: Description, Usage, Syntax, Examples and Explanation
  • Count rows that contain specific values in Excel

Data Analysis Examples

  • Get column index in Excel Table
  • How to calculate current stock or inventory in Excel
  • Calculate Conditional Percentile ‘IF’ in table in Excel
  • How to add Trendline to a chart in Excel
  • Excel Frequency Function Example

Data Validation Examples

  • Excel Data validation date in next 30 days
  • Excel Data validation must begin with
  • Excel Data validation must not contain
  • Excel Data validation require unique number
  • Excel Data validation no punctuation

Excel ABS function Example

by

The ABS function in Excel returns the absolute value of a number. In other words: the ABS function removes the minus sign (-) from a negative number, making it positive.

1. For example, the ABS function in cell B1 below returns the absolute value of a negative number.

Worked Example:   Change negative numbers to positive in Excel

The ABS function has no effect on 0 (zero) or positive numbers.

2. The absolute value of 0 is 0.

3. The absolute value of a positive number is the same positive number.

Worked Example:   Round a number to n significant digits in Excel

When do we need the ABS function in Excel?

4. For example, calculate the forecast error (difference between the actual and the forecast value) for each month.

Worked Example:   Find closest match in Excel

Note: if we look at the sum of these errors (zero), this forecast model seems perfect, but it’s not!

5. Simply use the ABS function to calculate the absolute error for each month.

Post navigation

Previous Post:

Forecast vs Trend Function in Excel

Next Post:

Conditional Formatting Icon Sets Examples in Excel

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others
  • How to extract word containing specific text in Excel
  • UNICHAR function: Description, Usage, Syntax, Examples and Explanation
  • Count Number of Words in Excel
  • LEFT, LEFTB functions: Description, Usage, Syntax, Examples and Explanation
  • How to count number of characters of text in a cell in Excel
  • Get first day of previous month in Excel
  • How to calculate nth day of year in Excel
  • Check If Two Dates are same month in Excel
  • ISOWEEKNUM function: Description, Usage, Syntax, Examples and Explanation
  • How to join date and text together in Excel
  • PPMT function: Description, Usage, Syntax, Examples and Explanation
  • ACCRINT function: Description, Usage, Syntax, Examples and Explanation
  • RRI function: Description, Usage, Syntax, Examples and Explanation
  • PV function: Description, Usage, Syntax, Examples and Explanation
  • How to calculate present value of annuity in excel
© 2022 xlsoffice . All Right Reserved. | Teal Smiles