Excel like a finance pro.
← The libraryPractice · 2 questions →
Engineering function
IMCOS
Returns the cosine of a complex number.
Rarely usedDifficulty 1500 · AdvancedUsage rank #492 of 520
When to use it
The cosine of a complex number.
The shape of it
- Syntax
=IMCOS(inumber)
Worked examples
Typical
=IMCOS("1+i") → 0.833730025131149-0.988897705762865i
A typical result.
Zero
=IMCOS("0") → 1
Cosine of zero.
Pure imaginary
=IMCOS("i") → 1.54308063481524
cos(i) is cosh(1), a real number.
Worth knowing
- Results are text with full precision.
- cos(x+iy) = cos x cosh y - i sin x sinh y.
- IMACOS does not exist; solve with IMLN.
Where it goes wrong
- #VALUE! for invalid text.
- Output precision looks noisy; wrap parts in ROUND if displaying.
Related
Learn the moves here — or let Wauvel run them on your numbers.
Meet your AI CFO →One CFO-grade Excel tip a week
A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.