Can I Spreadsheet?
← All functions

ISBETWEEN

Unsupported (not recognized)

Category: Operator · Last tested 2026-09-01

Real compatibility results for the ISBETWEEN function: executed in Excel for the web, Google Sheets and LibreOffice Calc, measured against Google’s published documentation. Excel does not document ISBETWEEN, so this page makes no claim about Excel. Syntax and links to that documentation are below.

Support matrix

EngineDocumentedLive-testedVerdict
Excel (desktop)No n/a (not an Excel function) n/a
Excel for the web— Yes (recalc, 2026-09-01) Unsupported (not recognized)
Google SheetsYes Yes (Drive import, 2026-09-01) Supported, behaves as documented
LibreOffice CalcNo Yes (25.8.7.3, 2026-09-01) Unsupported (not recognized)

LibreOffice version history

We executed the same test cases under each LibreOffice release to show exactly when ISBETWEEN’s support changed — not documentation claims, real results.

LibreOffice versionVerdictTested
24.2.0.3 Unsupported (not recognized) 2026-09-01
24.8.7.2 Unsupported (not recognized) 2026-09-01
25.2.0.3 Unsupported (not recognized) 2026-09-01
25.8.7.3 Unsupported (not recognized) 2026-09-01

Why isn't ISBETWEEN working in LibreOffice?

LibreOffice Calc does not implement ISBETWEEN as of 25.8.7.3 — in our executed tests it returns a #NAME? (unrecognized function) error. This is not a typo or a settings problem, and saving the file as .xlsx does not change it: the function simply isn’t available yet. Watch the LibreOffice version support page — we re-run every test on each new release, so it will flip to Supported here as soon as it lands.

Discovered quirks

Executed test cases

Excel for the web (executed 2026-09-01 via OneDrive recalculation)

These values come from Excel for the web, not from desktop Excel. They are two different implementations of the calculation engine, and this run measured only the web one: the corpus was uploaded to OneDrive as .xlsx, recalculated by Excel for the web on open, and downloaded again for readback. Excel for the web is a rolling service with no pinnable version, so the run is identified by its date. Where a value here disagrees with the Expected column — which is Microsoft’s documentation of the desktop product — we cannot tell you whether the web engine diverges from the desktop one or the documentation is wrong about both, because we do not run desktop Excel.

FormulaDescriptionResultExpectedVerdict
=ISBETWEEN(7.9, 1.2, 12.45) Published row 1: a value strictly inside the range, both flags defaulted #NAME? True
Provenance

This IS one of Google's own published results: the page carries a real Formula/Result table in the article body (not an embedded live sheet), and this row is quoted from it verbatim. ISBETWEEN is one of the few pages in this batch that publishes a complete Formula/Output table in the article body, so every case in this file is Google's own printed result rather than a derivation. The six rows below are the whole table. Google's ISBETWEEN page, read live on 2026-08-31 at https://support.google.com/docs/answer/10538337. BATCH PROVENANCE (batch H, the first Sheets/LibreOffice-only batch). Every function in this batch has x == false in docs/data/compat.json: it is a Google Sheets function that Microsoft does not document at all, so this corpus makes NO claim about it in that engine and nothing here is measured against that vendor's documentation. The authority is Google's own support.google.com function page, cited by full URL and by the date it was read -- Google publishes no version number for these pages, so a bare URL dates nothing. WHAT GOOGLE ACTUALLY PRINTS, WHICH IS LESS THAN IT LOOKS: most of these pages carry a 'Sample Usage' block of FORMULAS WITH NO RESULTS. Where a value below is Google's own published output the note says so; where it is derived from the page's stated semantics the note says that instead, and says from which sentence. No value in this batch was taken from a search snippet, a blog or a mirror. LIBREOFFICE: probed on all four pinned builds (24.2.0.3, 24.8.7.2, 25.2.0.3, 25.8.7.3) in five storage spellings -- plain, _xlfn., COM.MICROSOFT., ORG.OPENOFFICE. and _xlfn.ORG.OPENOFFICE. -- and #NAME? under every one of them, so the expected values below describe Google Sheets and the LibreOffice column records absence.

 Mismatch
=ISBETWEEN(1.2, 1.2, 12.45, TRUE) Published row 2: the lower bound itself, with lower_value_is_inclusive TRUE #NAME? True
Provenance

This IS one of Google's own published results: the page carries a real Formula/Result table in the article body (not an embedded live sheet), and this row is quoted from it verbatim. The argument description reads: "Whether the range of values includes the `lower_value`. By default this is TRUE". Google's ISBETWEEN page, read live on 2026-08-31 at https://support.google.com/docs/answer/10538337.

 Mismatch
=ISBETWEEN(1.2, 1.2, 12.45, FALSE) Published row 3: the same lower bound with the flag turned off #NAME? False
Provenance

This IS one of Google's own published results: the page carries a real Formula/Result table in the article body (not an embedded live sheet), and this row is quoted from it verbatim. Rows 2 and 3 differ only in that flag, which is what makes the pair worth executing. Google's ISBETWEEN page, read live on 2026-08-31 at https://support.google.com/docs/answer/10538337.

 Mismatch
=ISBETWEEN(12.45, 1.2, 12.45, TRUE, TRUE) Published row 4: the upper bound with both flags explicitly TRUE #NAME? True
Provenance

This IS one of Google's own published results: the page carries a real Formula/Result table in the article body (not an embedded live sheet), and this row is quoted from it verbatim. Google's ISBETWEEN page, read live on 2026-08-31 at https://support.google.com/docs/answer/10538337.

 Mismatch
=ISBETWEEN(12.45, 1.2, 12.45, TRUE, FALSE) Published row 5: the upper bound with upper_value_is_inclusive FALSE #NAME? False
Provenance

This IS one of Google's own published results: the page carries a real Formula/Result table in the article body (not an embedded live sheet), and this row is quoted from it verbatim. Google's ISBETWEEN page, read live on 2026-08-31 at https://support.google.com/docs/answer/10538337.

 Mismatch
=ISBETWEEN(7.9, 1.2, 12.45, FALSE, FALSE) Published row 6: an interior value is unaffected by either flag #NAME? True
Provenance

This IS one of Google's own published results: the page carries a real Formula/Result table in the article body (not an embedded live sheet), and this row is quoted from it verbatim. The row that shows the flags govern the endpoints only. THE PAGE SAYS NOTHING ABOUT TEXT OR DATES: all six published rows use plain numbers and no sentence on the page mentions comparing text or date values, so this corpus asserts nothing about them. Google's ISBETWEEN page, read live on 2026-08-31 at https://support.google.com/docs/answer/10538337.

 Mismatch

Google Sheets (executed 2026-09-01 via Drive import)

Google Sheets is a rolling service with no pinnable version, so this run is identified by its date. The corpus was imported to Drive as .xlsx, recalculated by Sheets, and exported back for readback.

FormulaDescriptionResultExpectedVerdict
=ISBETWEEN(7.9, 1.2, 12.45) Published row 1: a value strictly inside the range, both flags defaulted True True
Provenance

This IS one of Google's own published results: the page carries a real Formula/Result table in the article body (not an embedded live sheet), and this row is quoted from it verbatim. ISBETWEEN is one of the few pages in this batch that publishes a complete Formula/Output table in the article body, so every case in this file is Google's own printed result rather than a derivation. The six rows below are the whole table. Google's ISBETWEEN page, read live on 2026-08-31 at https://support.google.com/docs/answer/10538337. BATCH PROVENANCE (batch H, the first Sheets/LibreOffice-only batch). Every function in this batch has x == false in docs/data/compat.json: it is a Google Sheets function that Microsoft does not document at all, so this corpus makes NO claim about it in that engine and nothing here is measured against that vendor's documentation. The authority is Google's own support.google.com function page, cited by full URL and by the date it was read -- Google publishes no version number for these pages, so a bare URL dates nothing. WHAT GOOGLE ACTUALLY PRINTS, WHICH IS LESS THAN IT LOOKS: most of these pages carry a 'Sample Usage' block of FORMULAS WITH NO RESULTS. Where a value below is Google's own published output the note says so; where it is derived from the page's stated semantics the note says that instead, and says from which sentence. No value in this batch was taken from a search snippet, a blog or a mirror. LIBREOFFICE: probed on all four pinned builds (24.2.0.3, 24.8.7.2, 25.2.0.3, 25.8.7.3) in five storage spellings -- plain, _xlfn., COM.MICROSOFT., ORG.OPENOFFICE. and _xlfn.ORG.OPENOFFICE. -- and #NAME? under every one of them, so the expected values below describe Google Sheets and the LibreOffice column records absence.

 Matched
=ISBETWEEN(1.2, 1.2, 12.45, TRUE) Published row 2: the lower bound itself, with lower_value_is_inclusive TRUE True True
Provenance

This IS one of Google's own published results: the page carries a real Formula/Result table in the article body (not an embedded live sheet), and this row is quoted from it verbatim. The argument description reads: "Whether the range of values includes the `lower_value`. By default this is TRUE". Google's ISBETWEEN page, read live on 2026-08-31 at https://support.google.com/docs/answer/10538337.

 Matched
=ISBETWEEN(1.2, 1.2, 12.45, FALSE) Published row 3: the same lower bound with the flag turned off False False
Provenance

This IS one of Google's own published results: the page carries a real Formula/Result table in the article body (not an embedded live sheet), and this row is quoted from it verbatim. Rows 2 and 3 differ only in that flag, which is what makes the pair worth executing. Google's ISBETWEEN page, read live on 2026-08-31 at https://support.google.com/docs/answer/10538337.

 Matched
=ISBETWEEN(12.45, 1.2, 12.45, TRUE, TRUE) Published row 4: the upper bound with both flags explicitly TRUE True True
Provenance

This IS one of Google's own published results: the page carries a real Formula/Result table in the article body (not an embedded live sheet), and this row is quoted from it verbatim. Google's ISBETWEEN page, read live on 2026-08-31 at https://support.google.com/docs/answer/10538337.

 Matched
=ISBETWEEN(12.45, 1.2, 12.45, TRUE, FALSE) Published row 5: the upper bound with upper_value_is_inclusive FALSE False False
Provenance

This IS one of Google's own published results: the page carries a real Formula/Result table in the article body (not an embedded live sheet), and this row is quoted from it verbatim. Google's ISBETWEEN page, read live on 2026-08-31 at https://support.google.com/docs/answer/10538337.

 Matched
=ISBETWEEN(7.9, 1.2, 12.45, FALSE, FALSE) Published row 6: an interior value is unaffected by either flag True True
Provenance

This IS one of Google's own published results: the page carries a real Formula/Result table in the article body (not an embedded live sheet), and this row is quoted from it verbatim. The row that shows the flags govern the endpoints only. THE PAGE SAYS NOTHING ABOUT TEXT OR DATES: all six published rows use plain numbers and no sentence on the page mentions comparing text or date values, so this corpus asserts nothing about them. Google's ISBETWEEN page, read live on 2026-08-31 at https://support.google.com/docs/answer/10538337.

 Matched

LibreOffice Calc 25.8.7.3 (tested 2026-09-01)

FormulaDescriptionResultExpectedVerdict
=ISBETWEEN(7.9, 1.2, 12.45) Published row 1: a value strictly inside the range, both flags defaulted #NAME? True
Provenance

This IS one of Google's own published results: the page carries a real Formula/Result table in the article body (not an embedded live sheet), and this row is quoted from it verbatim. ISBETWEEN is one of the few pages in this batch that publishes a complete Formula/Output table in the article body, so every case in this file is Google's own printed result rather than a derivation. The six rows below are the whole table. Google's ISBETWEEN page, read live on 2026-08-31 at https://support.google.com/docs/answer/10538337. BATCH PROVENANCE (batch H, the first Sheets/LibreOffice-only batch). Every function in this batch has x == false in docs/data/compat.json: it is a Google Sheets function that Microsoft does not document at all, so this corpus makes NO claim about it in that engine and nothing here is measured against that vendor's documentation. The authority is Google's own support.google.com function page, cited by full URL and by the date it was read -- Google publishes no version number for these pages, so a bare URL dates nothing. WHAT GOOGLE ACTUALLY PRINTS, WHICH IS LESS THAN IT LOOKS: most of these pages carry a 'Sample Usage' block of FORMULAS WITH NO RESULTS. Where a value below is Google's own published output the note says so; where it is derived from the page's stated semantics the note says that instead, and says from which sentence. No value in this batch was taken from a search snippet, a blog or a mirror. LIBREOFFICE: probed on all four pinned builds (24.2.0.3, 24.8.7.2, 25.2.0.3, 25.8.7.3) in five storage spellings -- plain, _xlfn., COM.MICROSOFT., ORG.OPENOFFICE. and _xlfn.ORG.OPENOFFICE. -- and #NAME? under every one of them, so the expected values below describe Google Sheets and the LibreOffice column records absence.

 Mismatch
=ISBETWEEN(1.2, 1.2, 12.45, TRUE) Published row 2: the lower bound itself, with lower_value_is_inclusive TRUE #NAME? True
Provenance

This IS one of Google's own published results: the page carries a real Formula/Result table in the article body (not an embedded live sheet), and this row is quoted from it verbatim. The argument description reads: "Whether the range of values includes the `lower_value`. By default this is TRUE". Google's ISBETWEEN page, read live on 2026-08-31 at https://support.google.com/docs/answer/10538337.

 Mismatch
=ISBETWEEN(1.2, 1.2, 12.45, FALSE) Published row 3: the same lower bound with the flag turned off #NAME? False
Provenance

This IS one of Google's own published results: the page carries a real Formula/Result table in the article body (not an embedded live sheet), and this row is quoted from it verbatim. Rows 2 and 3 differ only in that flag, which is what makes the pair worth executing. Google's ISBETWEEN page, read live on 2026-08-31 at https://support.google.com/docs/answer/10538337.

 Mismatch
=ISBETWEEN(12.45, 1.2, 12.45, TRUE, TRUE) Published row 4: the upper bound with both flags explicitly TRUE #NAME? True
Provenance

This IS one of Google's own published results: the page carries a real Formula/Result table in the article body (not an embedded live sheet), and this row is quoted from it verbatim. Google's ISBETWEEN page, read live on 2026-08-31 at https://support.google.com/docs/answer/10538337.

 Mismatch
=ISBETWEEN(12.45, 1.2, 12.45, TRUE, FALSE) Published row 5: the upper bound with upper_value_is_inclusive FALSE #NAME? False
Provenance

This IS one of Google's own published results: the page carries a real Formula/Result table in the article body (not an embedded live sheet), and this row is quoted from it verbatim. Google's ISBETWEEN page, read live on 2026-08-31 at https://support.google.com/docs/answer/10538337.

 Mismatch
=ISBETWEEN(7.9, 1.2, 12.45, FALSE, FALSE) Published row 6: an interior value is unaffected by either flag #NAME? True
Provenance

This IS one of Google's own published results: the page carries a real Formula/Result table in the article body (not an embedded live sheet), and this row is quoted from it verbatim. The row that shows the flags govern the endpoints only. THE PAGE SAYS NOTHING ABOUT TEXT OR DATES: all six published rows use plain numbers and no sentence on the page mentions comparing text or date values, so this corpus asserts nothing about them. Google's ISBETWEEN page, read live on 2026-08-31 at https://support.google.com/docs/answer/10538337.

 Mismatch

Docs & syntax

Where ISBETWEEN behaves differently