IMTANH

GOOGLE'S OWN PUBLISHED RESULT, quoted verbatim from the Formula/Result table: =IMTANH(COMPLEX(4,1)) -> 1.00027905623447+0.00061024092137626i. Derived independently as tanh(4+i) = 1.000279056234465568359093202101514584404 + 0.000610240921376259785352673334029321933866i. NOTE THAT THE PAGE'S TWO LISTS DISAGREE ON THEIR INPUTS: the 'Sample formulas' block uses COMPLEX(4,6), 4 and "2+3i", while the Formula/Result table uses COMPLEX(4,1), 3.5 and "3+2i". Only the table's rows carry results, and only those are asserted here. 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. 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 IMTANH page, read live on 2026-08-31 at https://support.google.com/docs/answer/9366655. 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.

GOOGLE'S OWN PUBLISHED RESULT: =IMTANH(3.5) -> 0.998177897611199. Derived independently as tanh(3.5) = 0.9981778976111987092842733524506117173517. Google's IMTANH page, read live on 2026-08-31 at https://support.google.com/docs/answer/9366655.

GOOGLE'S OWN PUBLISHED RESULT: =IMTANH("3+2i") -> 1.00323862735361-0.00376402564150425i. Real part derived independently as 1.003238627353609801446358597821927259808. Google's IMTANH page, read live on 2026-08-31 at https://support.google.com/docs/answer/9366655.

The imaginary half of the same published result, derived independently as -0.003764025641504248292751221130322690839631. The sign is the point: IMCOTH on the same argument has a POSITIVE imaginary part, so this pair also checks that the two functions are not the same code. Google's IMTANH page, read live on 2026-08-31 at https://support.google.com/docs/answer/9366655.

GOOGLE'S OWN PUBLISHED RESULT, quoted verbatim from the Formula/Result table: =IMTANH(COMPLEX(4,1)) -> 1.00027905623447+0.00061024092137626i. Derived independently as tanh(4+i) = 1.000279056234465568359093202101514584404 + 0.000610240921376259785352673334029321933866i. NOTE THAT THE PAGE'S TWO LISTS DISAGREE ON THEIR INPUTS: the 'Sample formulas' block uses COMPLEX(4,6), 4 and "2+3i", while the Formula/Result table uses COMPLEX(4,1), 3.5 and "3+2i". Only the table's rows carry results, and only those are asserted here. 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. 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 IMTANH page, read live on 2026-08-31 at https://support.google.com/docs/answer/9366655. 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.

GOOGLE'S OWN PUBLISHED RESULT: =IMTANH(3.5) -> 0.998177897611199. Derived independently as tanh(3.5) = 0.9981778976111987092842733524506117173517. Google's IMTANH page, read live on 2026-08-31 at https://support.google.com/docs/answer/9366655.

GOOGLE'S OWN PUBLISHED RESULT: =IMTANH("3+2i") -> 1.00323862735361-0.00376402564150425i. Real part derived independently as 1.003238627353609801446358597821927259808. Google's IMTANH page, read live on 2026-08-31 at https://support.google.com/docs/answer/9366655.

The imaginary half of the same published result, derived independently as -0.003764025641504248292751221130322690839631. The sign is the point: IMCOTH on the same argument has a POSITIVE imaginary part, so this pair also checks that the two functions are not the same code. Google's IMTANH page, read live on 2026-08-31 at https://support.google.com/docs/answer/9366655.

GOOGLE'S OWN PUBLISHED RESULT, quoted verbatim from the Formula/Result table: =IMTANH(COMPLEX(4,1)) -> 1.00027905623447+0.00061024092137626i. Derived independently as tanh(4+i) = 1.000279056234465568359093202101514584404 + 0.000610240921376259785352673334029321933866i. NOTE THAT THE PAGE'S TWO LISTS DISAGREE ON THEIR INPUTS: the 'Sample formulas' block uses COMPLEX(4,6), 4 and "2+3i", while the Formula/Result table uses COMPLEX(4,1), 3.5 and "3+2i". Only the table's rows carry results, and only those are asserted here. 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. 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 IMTANH page, read live on 2026-08-31 at https://support.google.com/docs/answer/9366655. 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.

GOOGLE'S OWN PUBLISHED RESULT: =IMTANH(3.5) -> 0.998177897611199. Derived independently as tanh(3.5) = 0.9981778976111987092842733524506117173517. Google's IMTANH page, read live on 2026-08-31 at https://support.google.com/docs/answer/9366655.

GOOGLE'S OWN PUBLISHED RESULT: =IMTANH("3+2i") -> 1.00323862735361-0.00376402564150425i. Real part derived independently as 1.003238627353609801446358597821927259808. Google's IMTANH page, read live on 2026-08-31 at https://support.google.com/docs/answer/9366655.

The imaginary half of the same published result, derived independently as -0.003764025641504248292751221130322690839631. The sign is the point: IMCOTH on the same argument has a POSITIVE imaginary part, so this pair also checks that the two functions are not the same code. Google's IMTANH page, read live on 2026-08-31 at https://support.google.com/docs/answer/9366655.