Excel 16.0 build 20430
Windows, 64-bit, CPU not recorded
1,209 captured inputs are indexed for this environment. Capture dates: 2026-09-29 to 2026-09-29. This is a reading count, not a comparison with another build.
Engineering functions
Matches all 1,212 recorded answers
Recorded: 1,209 in the answer bank and 3 workbook cells. How we measure this · See the Rust code
| Language | Name in Excel |
|---|---|
| Arabic | IMCOS |
| Bulgarian | IMCOS |
| Czech | IMCOS |
| Danish | IMAGCOS |
| German | IMCOS |
| Greek | IMCOS |
| English (Australia) | IMCOS |
| English (United Kingdom) | IMCOS |
| English (United States) | IMCOS |
| Spanish | IM.COS |
| Estonian | IMCOS |
| Finnish | KOMPLEKSI.COS |
| French | COMPLEXE.COS |
| Hebrew | IMCOS |
| Croatian | IMCOS |
| Hungarian | KÉPZ.COS |
| Indonesian | IMCOS |
| Italian | IMCOS |
| Japanese | IMCOS |
| Korean | IMCOS |
| Lithuanian | IMCOS |
| Latvian | IMCOS |
| Norwegian | IMCOS |
| Dutch | C.COS |
| Polish | COS.LICZBY.ZESP |
| Portuguese (Brazil) | IMCOS |
| Portuguese (Portugal) | IMCOS |
| Romanian | IMCOS |
| Russian | МНИМ.COS |
| Slovak | IMCOS |
| Slovenian | IMCOS |
| Serbian (Latin) | IMCOS |
| Swedish | IMCOS |
| Thai | IMCOS |
| Turkish | SANCOS işlevi |
| Ukrainian | IMCOS |
| Vietnamese | IMCOS |
| Chinese (Simplified) | IMCOS |
| Chinese (Hong Kong) | IMCOS |
| Chinese (Traditional) | IMCOS |
Names from Microsoft's support site.
IMCOS(inumber)
IMCOS(inumber) returns the complex cosine. Real and imaginary coefficients use radians where a circular angle is involved. For pure imaginary bi, the mathematical result is the real cosh(b).
=IMCOS("i") gives real complex text about "1.54308063481524": its mathematical value is cosh(1). By contrast, the cosine of the real input 1 is about 0.5403. An imaginary coordinate changes circular cosine into hyperbolic growth.
Complex inputs use lowercase i or j, and the output is text. The current parser gives #NUM! for malformed complex text and the wrapper gives #VALUE! for logical values.
The current sine/cosine helper rejects a real coefficient with magnitude at least 134217728, through its circular leaf. Its imaginary exponential can overflow before the half-sum is formed. Real-only input, a large imaginary component and an ordinary non-real pair therefore test different parts of the route.
Parse the two coefficients and suffix before doing arithmetic; use the common complex formatter afterward. Retain suffix consistency, suppress a zero component and omit the coefficient one before the imaginary unit. Formatting and parsing have their own fifteen-significant-digit rules, so testing only the algebra misses observable behaviour.
For z=a+bi, the mathematical component formula is cos(a)*cosh(b) - i*sin(a)*sinh(b). The current sine/cosine route forms exp(b) using the worksheet exponential and a stored reciprocal for exp(-b), then forms the half-sum and half-difference. Independent sinh/cosh calls need not share that rounding history. The formula is a derivation aid; the named runtime leaves and stores in the current source define its implementation candidate. Validate text output as well as numeric components, and keep unmeasured rounding stages open.
Quoted from the public repository DnaCalc/DnaCalc, crates calc-func and calc-fml, at commit 9e1884369a67. Comments are the source's own. A kernel shared with other functions appears once, on its module page.
IMCOS · 1 lines · calc-func/src/catalogue/engineering.rs on GitHub36 imcos "IMCOS" (1, 1) [V "inumber"] |s, a, sv| { unary_complex(s, a, |z| Ok(z.cos())) }
complex_of catalogue/engineeringcomplex_text catalogue/engineeringunary_complex catalogue/engineeringnearest_even ported/complex_decimaldecimal_pair ported/complex_decimalparse_ascii_decimal_15 ported/complex_familyParsedComplex::new ported/complex_familyParsedComplex::abs ported/complex_familynormalize_zero ported/complex_familynumber_to_excel_text ported/complex_familyformat_complex_text ported/complex_familyparse_real_number ported/complex_familyfind_real_imag_split ported/complex_familyparse_imag_coeff ported/complex_familyparse_complex_text ported/complex_familysuffix_from_operands ported/complex_familyfail catalogue/kittext catalogue/kittext_value catalogue/kitNo implementation has been published with a Handbook test suite for this function.
The recorded environments below distinguish a reading from a same-input comparison. Counts describe captured inputs in each environment; overlapping captures and comparisons are not totals of unique worksheet calls.
| Excel 16.0 build | Platform and CPU | Captured inputs |
|---|---|---|
| 20430 | Windows, 64-bit, CPU not recorded | 1,209 |
The record contains no same-input comparison between these environments. Reading different inputs on different builds does not establish either a version change or cross-build agreement.
Recorded environments and comparison details.
Windows, 64-bit, CPU not recorded
1,209 captured inputs are indexed for this environment. Capture dates: 2026-09-29 to 2026-09-29. This is a reading count, not a comparison with another build.
IMEXP expresses the exponential relation; IMSIN is a related circular function; COMPLEX constructs the input.
No named variants are recorded yet.
Suggest a correction or contribute an implementation · For agents