Engineering functions

IMCOS

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

Local names in 40 languages
LanguageName in Excel
ArabicIMCOS
BulgarianIMCOS
CzechIMCOS
DanishIMAGCOS
GermanIMCOS
GreekIMCOS
English (Australia)IMCOS
English (United Kingdom)IMCOS
English (United States)IMCOS
SpanishIM.COS
EstonianIMCOS
FinnishKOMPLEKSI.COS
FrenchCOMPLEXE.COS
HebrewIMCOS
CroatianIMCOS
HungarianKÉPZ.COS
IndonesianIMCOS
ItalianIMCOS
JapaneseIMCOS
KoreanIMCOS
LithuanianIMCOS
LatvianIMCOS
NorwegianIMCOS
DutchC.COS
PolishCOS.LICZBY.ZESP
Portuguese (Brazil)IMCOS
Portuguese (Portugal)IMCOS
RomanianIMCOS
RussianМНИМ.COS
SlovakIMCOS
SlovenianIMCOS
Serbian (Latin)IMCOS
SwedishIMCOS
ThaiIMCOS
TurkishSANCOS işlevi
UkrainianIMCOS
VietnameseIMCOS
Chinese (Simplified)IMCOS
Chinese (Hong Kong)IMCOS
Chinese (Traditional)IMCOS

Names from Microsoft's support site.

What it does

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).

Try it

Input cells (optional)

Example: {"B2": 3, "B3": 4}. A1 holds the formula. Other cells need values before a formula can read them.

Enter a formula, then calculate.

Runs locally in your browser with OneCalc. Its answer may differ from Excel. Use English function names and commas between arguments.

=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.

Quirks

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.

How to implement

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.

Rust code

Show the CalcFunc source of this function

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 GitHub
36 imcos "IMCOS" (1, 1) [V "inumber"] |s, a, sv| { unary_complex(s, a, |z| Ok(z.cos())) }

Kernels shared with other functions

Argument and result plumbing

No implementation has been published with a Handbook test suite for this function.

Version differences

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 buildPlatform and CPUCaptured inputs
20430Windows, 64-bit, CPU not recorded1,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.

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.

Alternatives

IMEXP expresses the exponential relation; IMSIN is a related circular function; COMPLEX constructs the input.

Named variants

No named variants are recorded yet.

Suggest a correction or contribute an implementation · For agents