IMLOG
Unsupported (not recognized)Category: Engineering · Last tested 2026-09-01
Real compatibility results for the IMLOG function: executed in Excel for the web, Google Sheets and LibreOffice Calc, measured against Google’s published documentation. Excel does not document IMLOG, so this page makes no claim about Excel. Syntax and links to that documentation are below.
Support matrix
| Engine | Documented | Live-tested | Verdict |
|---|---|---|---|
| Excel (desktop) | No | n/a (not an Excel function) | n/a |
| Excel for the web | — | Yes (recalc, 2026-09-01) | Unsupported (not recognized) |
| Google Sheets | Yes | Yes (Drive import, 2026-09-01) | Supported, behaves as documented |
| LibreOffice Calc | No | 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 IMLOG’s support changed — not documentation claims, real results.
| LibreOffice version | Verdict | Tested |
|---|---|---|
| 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 IMLOG working in LibreOffice?
LibreOffice Calc does not implement IMLOG 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
-
=IMLOG(100,10) on
Excel for the web returned
#NAME?, but the documented/expected
result is 2.
Provenance
TYPE CORRECTION (2026-09-01, post-ingest): first authored as the number 2; the executed engine returns the TEXT string '2' -- like every IM* function, IMLOG returns complex results as text, and Google's published table prints the figure typelessly. The expected is now the string, matching the engine's actual (and documented-family-consistent) return type; the printed figure itself was never in dispute. GOOGLE'S OWN PUBLISHED RESULT: =IMLOG(100, 10) -> 2. IMLOG's page is the only one of the three complex pages in this batch whose Sample-formulas inputs and Formula/Result table rows MATCH each other, so its three published results can be paired with its three samples directly. INDEPENDENT DERIVATION. Every figure quoted from these three pages was recomputed here at 40 decimal digits with mpmath before it was written down -- coth/tanh/log evaluated directly on the complex argument -- and all nine of Google's published results reproduce EXACTLY at the 15 significant digits the pages print, correctly rounded. Nothing on these pages needed correcting. Google's IMLOG page, read live on 2026-08-31 at https://support.google.com/docs/answer/9366486. 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 vs expected: expected '2', got '#NAME?'
-
=IMLOG("1+i", 3.5) on
Excel for the web returned
#NAME?, but the documented/expected
result is 0.276647377832556+0.626932774314643i.
Provenance
GOOGLE'S OWN PUBLISHED RESULT, quoted verbatim: =IMLOG("1+i", 3.5) -> 0.276647377832556+0.626932774314643i. Derived independently as log(1+i)/log(3.5) = 0.2766473778325561086024443610317785858615 + 0.6269327743146426385843035649172255217738i. NOTE THAT THE PAGE NEVER STATES A BRANCH: there is no sentence about the principal value or the branch cut of the complex logarithm anywhere on it, so this case asserts the published value and the corpus asserts nothing about arguments where the branch would matter. NOTE ON THE RESULT FORMAT, WHICH THE PAGE NEVER STATES. None of the three pages contains a sentence describing the shape of the returned complex value -- no "a+bi" rule, no i-versus-j statement, no precision or rounding rule. The format is visible ONLY in the literal result strings the pages print. That is why this file asserts the string form in exactly one case per function and asserts the numeric components through IMREAL/IMAGINARY everywhere else: a difference in formatting and a difference in the mathematics are different findings and should not be able to masquerade as each other. Google's IMLOG page, read live on 2026-08-31 at https://support.google.com/docs/answer/9366486.; MISMATCH vs expected: expected '0.276647377832556+0.626932774314643i', got '#NAME?'
-
=ROUND(IMREAL(IMLOG(COMPLEX(25, 34), 2.3)),14) on
Excel for the web returned
#NAME?, but the documented/expected
result is 4.49324546771284.
Provenance
GOOGLE'S OWN PUBLISHED RESULT: =IMLOG(COMPLEX(25, 34), 2.3) -> 4.49324546771284+1.12470086031758i. Real part derived independently as 4.493245467712837686199121881993797704048. The base argument is the only one the page constrains: "Must be a positive real number." No default is stated and the page presents base as required. Google's IMLOG page, read live on 2026-08-31 at https://support.google.com/docs/answer/9366486.; MISMATCH vs expected: expected 4.49324546771284, got '#NAME?'
-
=ROUND(IMAGINARY(IMLOG(COMPLEX(25, 34), 2.3)),14) on
Excel for the web returned
#NAME?, but the documented/expected
result is 1.12470086031758.
Provenance
The imaginary half of the same published result, derived independently as 1.124700860317582465513509687755013399277. Google's IMLOG page, read live on 2026-08-31 at https://support.google.com/docs/answer/9366486.; MISMATCH vs expected: expected 1.12470086031758, got '#NAME?'
-
=ROUND(IMLOG(100,10)-LOG(100,10),12) on
Excel for the web returned
#NAME?, but the documented/expected
result is 0.
Provenance
A structural assertion with no derived constant. The Notes bullet reads: "IMLOG is equivalent to LOG for all non-complex values that are greater than zero." Google's IMLOG page, read live on 2026-08-31 at https://support.google.com/docs/answer/9366486.; MISMATCH vs expected: expected 0, got '#NAME?'
-
=ROUND(IMABS(IMSUB(IMLOG("1+i",2),IMLOG2("1+i"))),12) on
Excel for the web returned
#NAME?, but the documented/expected
result is 0.
Provenance
A structural assertion with no derived constant, from the Notes bullet "IMLOG is equivalent to IMLOG2 given base of 2." Asserted on "1+i" rather than a real, because that is where the two implementations could differ without any published example noticing. Compared through IMABS of the difference, since complex results are strings. Google's IMLOG page, read live on 2026-08-31 at https://support.google.com/docs/answer/9366486.; MISMATCH vs expected: expected 0, got '#NAME?'
-
=IMLOG(100,10) on
LibreOffice Calc returned
#NAME?, but the documented/expected
result is 2.
Provenance
GOOGLE'S OWN PUBLISHED RESULT: =IMLOG(100, 10) -> 2. IMLOG's page is the only one of the three complex pages in this batch whose Sample-formulas inputs and Formula/Result table rows MATCH each other, so its three published results can be paired with its three samples directly. INDEPENDENT DERIVATION. Every figure quoted from these three pages was recomputed here at 40 decimal digits with mpmath before it was written down -- coth/tanh/log evaluated directly on the complex argument -- and all nine of Google's published results reproduce EXACTLY at the 15 significant digits the pages print, correctly rounded. Nothing on these pages needed correcting. Google's IMLOG page, read live on 2026-08-31 at https://support.google.com/docs/answer/9366486. 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 vs expected: expected 2, got '#NAME?'
-
=IMLOG("1+i", 3.5) on
LibreOffice Calc returned
#NAME?, but the documented/expected
result is 0.276647377832556+0.626932774314643i.
Provenance
GOOGLE'S OWN PUBLISHED RESULT, quoted verbatim: =IMLOG("1+i", 3.5) -> 0.276647377832556+0.626932774314643i. Derived independently as log(1+i)/log(3.5) = 0.2766473778325561086024443610317785858615 + 0.6269327743146426385843035649172255217738i. NOTE THAT THE PAGE NEVER STATES A BRANCH: there is no sentence about the principal value or the branch cut of the complex logarithm anywhere on it, so this case asserts the published value and the corpus asserts nothing about arguments where the branch would matter. NOTE ON THE RESULT FORMAT, WHICH THE PAGE NEVER STATES. None of the three pages contains a sentence describing the shape of the returned complex value -- no "a+bi" rule, no i-versus-j statement, no precision or rounding rule. The format is visible ONLY in the literal result strings the pages print. That is why this file asserts the string form in exactly one case per function and asserts the numeric components through IMREAL/IMAGINARY everywhere else: a difference in formatting and a difference in the mathematics are different findings and should not be able to masquerade as each other. Google's IMLOG page, read live on 2026-08-31 at https://support.google.com/docs/answer/9366486.; MISMATCH vs expected: expected '0.276647377832556+0.626932774314643i', got '#NAME?'
-
=ROUND(IMREAL(IMLOG(COMPLEX(25, 34), 2.3)),14) on
LibreOffice Calc returned
#NAME?, but the documented/expected
result is 4.49324546771284.
Provenance
GOOGLE'S OWN PUBLISHED RESULT: =IMLOG(COMPLEX(25, 34), 2.3) -> 4.49324546771284+1.12470086031758i. Real part derived independently as 4.493245467712837686199121881993797704048. The base argument is the only one the page constrains: "Must be a positive real number." No default is stated and the page presents base as required. Google's IMLOG page, read live on 2026-08-31 at https://support.google.com/docs/answer/9366486.; MISMATCH vs expected: expected 4.49324546771284, got '#NAME?'
-
=ROUND(IMAGINARY(IMLOG(COMPLEX(25, 34), 2.3)),14) on
LibreOffice Calc returned
#NAME?, but the documented/expected
result is 1.12470086031758.
Provenance
The imaginary half of the same published result, derived independently as 1.124700860317582465513509687755013399277. Google's IMLOG page, read live on 2026-08-31 at https://support.google.com/docs/answer/9366486.; MISMATCH vs expected: expected 1.12470086031758, got '#NAME?'
-
=ROUND(IMLOG(100,10)-LOG(100,10),12) on
LibreOffice Calc returned
#NAME?, but the documented/expected
result is 0.
Provenance
A structural assertion with no derived constant. The Notes bullet reads: "IMLOG is equivalent to LOG for all non-complex values that are greater than zero." Google's IMLOG page, read live on 2026-08-31 at https://support.google.com/docs/answer/9366486.; MISMATCH vs expected: expected 0, got '#NAME?'
-
=ROUND(IMABS(IMSUB(IMLOG("1+i",2),IMLOG2("1+i"))),12) on
LibreOffice Calc returned
#NAME?, but the documented/expected
result is 0.
Provenance
A structural assertion with no derived constant, from the Notes bullet "IMLOG is equivalent to IMLOG2 given base of 2." Asserted on "1+i" rather than a real, because that is where the two implementations could differ without any published example noticing. Compared through IMABS of the difference, since complex results are strings. Google's IMLOG page, read live on 2026-08-31 at https://support.google.com/docs/answer/9366486.; MISMATCH vs expected: expected 0, got '#NAME?'
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.
| Formula | Description | Result | Expected | Verdict |
|---|---|---|---|---|
| =IMLOG(100,10) | Published row 3: a real argument and base 10, whose result is an integer | #NAME? | 2ProvenanceTYPE CORRECTION (2026-09-01, post-ingest): first authored as the number 2; the executed engine returns the TEXT string '2' -- like every IM* function, IMLOG returns complex results as text, and Google's published table prints the figure typelessly. The expected is now the string, matching the engine's actual (and documented-family-consistent) return type; the printed figure itself was never in dispute. GOOGLE'S OWN PUBLISHED RESULT: =IMLOG(100, 10) -> 2. IMLOG's page is the only one of the three complex pages in this batch whose Sample-formulas inputs and Formula/Result table rows MATCH each other, so its three published results can be paired with its three samples directly. INDEPENDENT DERIVATION. Every figure quoted from these three pages was recomputed here at 40 decimal digits with mpmath before it was written down -- coth/tanh/log evaluated directly on the complex argument -- and all nine of Google's published results reproduce EXACTLY at the 15 significant digits the pages print, correctly rounded. Nothing on these pages needed correcting. Google's IMLOG page, read live on 2026-08-31 at https://support.google.com/docs/answer/9366486. 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 |
| =IMLOG("1+i", 3.5) | Published row 1, asserted as the exact result string Google prints | #NAME? | 0.276647377832556+0.626932774314643iProvenanceGOOGLE'S OWN PUBLISHED RESULT, quoted verbatim: =IMLOG("1+i", 3.5) -> 0.276647377832556+0.626932774314643i. Derived independently as log(1+i)/log(3.5) = 0.2766473778325561086024443610317785858615 + 0.6269327743146426385843035649172255217738i. NOTE THAT THE PAGE NEVER STATES A BRANCH: there is no sentence about the principal value or the branch cut of the complex logarithm anywhere on it, so this case asserts the published value and the corpus asserts nothing about arguments where the branch would matter. NOTE ON THE RESULT FORMAT, WHICH THE PAGE NEVER STATES. None of the three pages contains a sentence describing the shape of the returned complex value -- no "a+bi" rule, no i-versus-j statement, no precision or rounding rule. The format is visible ONLY in the literal result strings the pages print. That is why this file asserts the string form in exactly one case per function and asserts the numeric components through IMREAL/IMAGINARY everywhere else: a difference in formatting and a difference in the mathematics are different findings and should not be able to masquerade as each other. Google's IMLOG page, read live on 2026-08-31 at https://support.google.com/docs/answer/9366486. |
Mismatch |
| =ROUND(IMREAL(IMLOG(COMPLEX(25, 34), 2.3)),14) | Published row 2, real part, on a non-integer base | #NAME? | 4.49324546771284ProvenanceGOOGLE'S OWN PUBLISHED RESULT: =IMLOG(COMPLEX(25, 34), 2.3) -> 4.49324546771284+1.12470086031758i. Real part derived independently as 4.493245467712837686199121881993797704048. The base argument is the only one the page constrains: "Must be a positive real number." No default is stated and the page presents base as required. Google's IMLOG page, read live on 2026-08-31 at https://support.google.com/docs/answer/9366486. |
Mismatch |
| =ROUND(IMAGINARY(IMLOG(COMPLEX(25, 34), 2.3)),14) | The imaginary part of the same published row | #NAME? | 1.12470086031758ProvenanceThe imaginary half of the same published result, derived independently as 1.124700860317582465513509687755013399277. Google's IMLOG page, read live on 2026-08-31 at https://support.google.com/docs/answer/9366486. |
Mismatch |
| =ROUND(IMLOG(100,10)-LOG(100,10),12) | The first documented equivalence, asserted structurally | #NAME? | 0ProvenanceA structural assertion with no derived constant. The Notes bullet reads: "IMLOG is equivalent to LOG for all non-complex values that are greater than zero." Google's IMLOG page, read live on 2026-08-31 at https://support.google.com/docs/answer/9366486. |
Mismatch |
| =ROUND(IMABS(IMSUB(IMLOG("1+i",2),IMLOG2("1+i"))),12) | The base-2 documented equivalence, on a genuinely complex argument | #NAME? | 0ProvenanceA structural assertion with no derived constant, from the Notes bullet "IMLOG is equivalent to IMLOG2 given base of 2." Asserted on "1+i" rather than a real, because that is where the two implementations could differ without any published example noticing. Compared through IMABS of the difference, since complex results are strings. Google's IMLOG page, read live on 2026-08-31 at https://support.google.com/docs/answer/9366486. |
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.
| Formula | Description | Result | Expected | Verdict |
|---|---|---|---|---|
| =IMLOG(100,10) | Published row 3: a real argument and base 10, whose result is an integer | 2 | 2ProvenanceTYPE CORRECTION (2026-09-01, post-ingest): first authored as the number 2; the executed engine returns the TEXT string '2' -- like every IM* function, IMLOG returns complex results as text, and Google's published table prints the figure typelessly. The expected is now the string, matching the engine's actual (and documented-family-consistent) return type; the printed figure itself was never in dispute. GOOGLE'S OWN PUBLISHED RESULT: =IMLOG(100, 10) -> 2. IMLOG's page is the only one of the three complex pages in this batch whose Sample-formulas inputs and Formula/Result table rows MATCH each other, so its three published results can be paired with its three samples directly. INDEPENDENT DERIVATION. Every figure quoted from these three pages was recomputed here at 40 decimal digits with mpmath before it was written down -- coth/tanh/log evaluated directly on the complex argument -- and all nine of Google's published results reproduce EXACTLY at the 15 significant digits the pages print, correctly rounded. Nothing on these pages needed correcting. Google's IMLOG page, read live on 2026-08-31 at https://support.google.com/docs/answer/9366486. 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 |
| =IMLOG("1+i", 3.5) | Published row 1, asserted as the exact result string Google prints | 0.276647377832556+0.626932774314643i | 0.276647377832556+0.626932774314643iProvenanceGOOGLE'S OWN PUBLISHED RESULT, quoted verbatim: =IMLOG("1+i", 3.5) -> 0.276647377832556+0.626932774314643i. Derived independently as log(1+i)/log(3.5) = 0.2766473778325561086024443610317785858615 + 0.6269327743146426385843035649172255217738i. NOTE THAT THE PAGE NEVER STATES A BRANCH: there is no sentence about the principal value or the branch cut of the complex logarithm anywhere on it, so this case asserts the published value and the corpus asserts nothing about arguments where the branch would matter. NOTE ON THE RESULT FORMAT, WHICH THE PAGE NEVER STATES. None of the three pages contains a sentence describing the shape of the returned complex value -- no "a+bi" rule, no i-versus-j statement, no precision or rounding rule. The format is visible ONLY in the literal result strings the pages print. That is why this file asserts the string form in exactly one case per function and asserts the numeric components through IMREAL/IMAGINARY everywhere else: a difference in formatting and a difference in the mathematics are different findings and should not be able to masquerade as each other. Google's IMLOG page, read live on 2026-08-31 at https://support.google.com/docs/answer/9366486. |
Matched |
| =ROUND(IMREAL(IMLOG(COMPLEX(25, 34), 2.3)),14) | Published row 2, real part, on a non-integer base | 4.493245468 | 4.49324546771284ProvenanceGOOGLE'S OWN PUBLISHED RESULT: =IMLOG(COMPLEX(25, 34), 2.3) -> 4.49324546771284+1.12470086031758i. Real part derived independently as 4.493245467712837686199121881993797704048. The base argument is the only one the page constrains: "Must be a positive real number." No default is stated and the page presents base as required. Google's IMLOG page, read live on 2026-08-31 at https://support.google.com/docs/answer/9366486. |
Matched |
| =ROUND(IMAGINARY(IMLOG(COMPLEX(25, 34), 2.3)),14) | The imaginary part of the same published row | 1.12470086 | 1.12470086031758ProvenanceThe imaginary half of the same published result, derived independently as 1.124700860317582465513509687755013399277. Google's IMLOG page, read live on 2026-08-31 at https://support.google.com/docs/answer/9366486. |
Matched |
| =ROUND(IMLOG(100,10)-LOG(100,10),12) | The first documented equivalence, asserted structurally | 0 | 0ProvenanceA structural assertion with no derived constant. The Notes bullet reads: "IMLOG is equivalent to LOG for all non-complex values that are greater than zero." Google's IMLOG page, read live on 2026-08-31 at https://support.google.com/docs/answer/9366486. |
Matched |
| =ROUND(IMABS(IMSUB(IMLOG("1+i",2),IMLOG2("1+i"))),12) | The base-2 documented equivalence, on a genuinely complex argument | 0 | 0ProvenanceA structural assertion with no derived constant, from the Notes bullet "IMLOG is equivalent to IMLOG2 given base of 2." Asserted on "1+i" rather than a real, because that is where the two implementations could differ without any published example noticing. Compared through IMABS of the difference, since complex results are strings. Google's IMLOG page, read live on 2026-08-31 at https://support.google.com/docs/answer/9366486. |
Matched |
LibreOffice Calc 25.8.7.3 (tested 2026-09-01)
| Formula | Description | Result | Expected | Verdict |
|---|---|---|---|---|
| =IMLOG(100,10) | Published row 3: a real argument and base 10, whose result is an integer | #NAME? | 2ProvenanceTYPE CORRECTION (2026-09-01, post-ingest): first authored as the number 2; the executed engine returns the TEXT string '2' -- like every IM* function, IMLOG returns complex results as text, and Google's published table prints the figure typelessly. The expected is now the string, matching the engine's actual (and documented-family-consistent) return type; the printed figure itself was never in dispute. GOOGLE'S OWN PUBLISHED RESULT: =IMLOG(100, 10) -> 2. IMLOG's page is the only one of the three complex pages in this batch whose Sample-formulas inputs and Formula/Result table rows MATCH each other, so its three published results can be paired with its three samples directly. INDEPENDENT DERIVATION. Every figure quoted from these three pages was recomputed here at 40 decimal digits with mpmath before it was written down -- coth/tanh/log evaluated directly on the complex argument -- and all nine of Google's published results reproduce EXACTLY at the 15 significant digits the pages print, correctly rounded. Nothing on these pages needed correcting. Google's IMLOG page, read live on 2026-08-31 at https://support.google.com/docs/answer/9366486. 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 |
| =IMLOG("1+i", 3.5) | Published row 1, asserted as the exact result string Google prints | #NAME? | 0.276647377832556+0.626932774314643iProvenanceGOOGLE'S OWN PUBLISHED RESULT, quoted verbatim: =IMLOG("1+i", 3.5) -> 0.276647377832556+0.626932774314643i. Derived independently as log(1+i)/log(3.5) = 0.2766473778325561086024443610317785858615 + 0.6269327743146426385843035649172255217738i. NOTE THAT THE PAGE NEVER STATES A BRANCH: there is no sentence about the principal value or the branch cut of the complex logarithm anywhere on it, so this case asserts the published value and the corpus asserts nothing about arguments where the branch would matter. NOTE ON THE RESULT FORMAT, WHICH THE PAGE NEVER STATES. None of the three pages contains a sentence describing the shape of the returned complex value -- no "a+bi" rule, no i-versus-j statement, no precision or rounding rule. The format is visible ONLY in the literal result strings the pages print. That is why this file asserts the string form in exactly one case per function and asserts the numeric components through IMREAL/IMAGINARY everywhere else: a difference in formatting and a difference in the mathematics are different findings and should not be able to masquerade as each other. Google's IMLOG page, read live on 2026-08-31 at https://support.google.com/docs/answer/9366486. |
Mismatch |
| =ROUND(IMREAL(IMLOG(COMPLEX(25, 34), 2.3)),14) | Published row 2, real part, on a non-integer base | #NAME? | 4.49324546771284ProvenanceGOOGLE'S OWN PUBLISHED RESULT: =IMLOG(COMPLEX(25, 34), 2.3) -> 4.49324546771284+1.12470086031758i. Real part derived independently as 4.493245467712837686199121881993797704048. The base argument is the only one the page constrains: "Must be a positive real number." No default is stated and the page presents base as required. Google's IMLOG page, read live on 2026-08-31 at https://support.google.com/docs/answer/9366486. |
Mismatch |
| =ROUND(IMAGINARY(IMLOG(COMPLEX(25, 34), 2.3)),14) | The imaginary part of the same published row | #NAME? | 1.12470086031758ProvenanceThe imaginary half of the same published result, derived independently as 1.124700860317582465513509687755013399277. Google's IMLOG page, read live on 2026-08-31 at https://support.google.com/docs/answer/9366486. |
Mismatch |
| =ROUND(IMLOG(100,10)-LOG(100,10),12) | The first documented equivalence, asserted structurally | #NAME? | 0ProvenanceA structural assertion with no derived constant. The Notes bullet reads: "IMLOG is equivalent to LOG for all non-complex values that are greater than zero." Google's IMLOG page, read live on 2026-08-31 at https://support.google.com/docs/answer/9366486. |
Mismatch |
| =ROUND(IMABS(IMSUB(IMLOG("1+i",2),IMLOG2("1+i"))),12) | The base-2 documented equivalence, on a genuinely complex argument | #NAME? | 0ProvenanceA structural assertion with no derived constant, from the Notes bullet "IMLOG is equivalent to IMLOG2 given base of 2." Asserted on "1+i" rather than a real, because that is where the two implementations could differ without any published example noticing. Compared through IMABS of the difference, since complex results are strings. Google's IMLOG page, read live on 2026-08-31 at https://support.google.com/docs/answer/9366486. |
Mismatch |
Docs & syntax
- Google Sheets: official documentation