What is the syntax for COTH in Excel?

The syntax for COTH is: =COTH(number)

How do I use the COTH function?

To use COTH, type =COTH( in a cell and provide the required arguments. Excel will show you the syntax and parameter hints as you type. Make sure to close the parentheses and press Enter to execute the function.

What happens if COTH encounters errors?

If COTH encounters invalid arguments or calculation errors, it may return error values like #VALUE!, #NUM!, or #DIV/0!. Check your input values and ensure they meet the function's requirements.

Why is COTH not working in my Excel?

Common issues with COTH include #DIV/0! when number is 0. Start by checking the syntax =COTH(number), then verify each referenced cell or range.

Math & Trig

COTH Function in Excel

Returns the hyperbolic cotangent of a number.

Syntax

=COTH(number)

Arguments

number (required): Any real number except 0

Examples

=COTH(1) - Hyperbolic cotangent of 1 - Result: 1.313

COTH in reporting workflows

Use absolute references when copying formulas across rows.
For conditional totals see [SUMIF](/functions/sumif/) and [SUMIFS](/functions/sumifs/).
Filtered lists may need [SUBTOTAL](/functions/subtotal/) instead of SUM on visible cells only.

Common errors

#DIV/0! when number is 0

Use cases

Engineering
Physics
Mathematics

Frequently asked questions

What is the COTH function in Excel? COTH returns the hyperbolic cotangent of a number. The syntax is =COTH(number). Typical use cases include engineering, physics, mathematics.
How do I use the COTH function? To use COTH, type =COTH( in a cell and provide the required arguments. Excel will show you the syntax and parameter hints as you type. Make sure to close the parentheses and press Enter to execute the function.
What happens if COTH encounters errors? If COTH encounters invalid arguments or calculation errors, it may return error values like #VALUE!, #NUM!, or #DIV/0!. Check your input values and ensure they meet the function's requirements.
Why is COTH not working in my Excel? Common issues with COTH include #DIV/0! when number is 0. Start by checking the syntax =COTH(number), then verify each referenced cell or range.

Editorial review

Reviewed by Excel.Directory Editorial Team. Updated May 2026.