ADDRESS
Supported, behaves as documentedCategory: Lookup and reference · Last tested 2026-07-04
Support matrix
| Engine | Documented | Live-tested | Verdict |
|---|---|---|---|
| Excel | Yes | Not yet | n/a |
| Google Sheets | Yes | Not yet | n/a |
| LibreOffice Calc | Yes | Yes (24.2.7.2, 2026-07-04) | Supported, behaves as documented |
Executed test cases
LibreOffice Calc 24.2.7.2 (tested 2026-07-04)
| Formula | Description | Result | Expected | Verdict |
|---|---|---|---|---|
| =ADDRESS(2,3) | abs_num omitted defaults to 1 (fully absolute) | $C$2 | $C$2 https://support.microsoft.com/en-us/office/address-function-d0c26c0d-3991-446b-8de4-ab46431d4f89 -- abs_num default is 1 (absolute); row 2, column 3 = C, giving $C$2 |
Matched |
| =ADDRESS(2,3,1) | abs_num=1: absolute row and absolute column | $C$2 | $C$2 | Matched |
| =ADDRESS(2,3,2) | abs_num=2: absolute row, relative column | C$2 | C$2 Per the ADDRESS docs' abs_num table, mode 2 locks the row with $ but leaves the column floating |
Matched |
| =ADDRESS(2,3,3) | abs_num=3: relative row, absolute column | $C2 | $C2 Mode 3 is the mirror of mode 2: column locked with $, row left relative |
Matched |
| =ADDRESS(2,3,4) | abs_num=4: fully relative, no dollar signs | C2 | C2 | Matched |
| =ADDRESS(1,1,1,TRUE,"Sheet1") | sheet_text argument prefixes the result with a sheet-qualified reference | Sheet1!$A$1 | Sheet1!$A$1 | Matched |
Docs & syntax
- Excel: official documentation
- Google Sheets: official documentation
- LibreOffice Calc: official documentation