ABSDB Function (LibreOffice Calc)

• Returns the absolute value of a number
• Accepts direct numeric input or database field references
• Useful in legacy models where values are pulled from external data sources
• Behaves similarly to ABS, but exists for compatibility with older database‑linked sheets

ABSDB(number)

Arguments

• number:
  A numeric value or a reference to a database field containing a number.

Absolute value of a number

=ABSDB(-42)
→ 42

Absolute value of a cell reference

=ABSDB(A1)

Absolute value of a database field reference

=ABSDB('sales.dbf'.Amount)

Normalize imported negative values

=ABSDB(VLOOKUP(ID; SalesTable; 3; 0))

Clean up sign‑flipped accounting data

=ABSDB(DATEVALUE(A1) - DATEVALUE(A2))

Combine with ROUND

=ROUND(ABSDB(A1); 2)

Combine with CONVERT for unit‑normalized absolute values

=ABSDB(CONVERT(A1; "ft"; "m"))

ABSDB returns a numeric value

Accepts:

• Numbers
• Cell references
• Database field references
• Expressions that evaluate to numbers

Invalid text → Err:502

Behavior details

• ABSDB is functionally equivalent to ABS for most modern spreadsheets
• Exists primarily for compatibility with older database‑linked models
• Does not modify the underlying data source
• Non‑numeric input results in an error

ABSDB of an error → error propagates

• Prefer ABS for modern spreadsheets
• Use ABSDB only when maintaining legacy database‑linked models
• Validate database field types before applying ABSDB
• Combine with VALUE to sanitize imported text‑numbers

• Use ABS for standard absolute‑value operations
• Use VALUE to convert text to numbers
• Use ROUND, TRUNC, or INT for numeric shaping
• Use CONVERT for unit‑normalized absolute values

By mastering ABSDB and its modern alternatives, you can maintain compatibility with legacy database‑driven spreadsheets while building clean, reliable numeric workflows in LibreOffice Calc.