TAN Function in Excel: Tangent of an Angle

⏱ 1 min readUpdated 28 September 2026

MathLevel: IntermediateAvailable in: Excel 2007+

In this article
  1. Syntax
  2. Examples
  3. Example 1
  4. Related functions

TAN links an angle to a slope. Radians again — wrap degrees in RADIANS().

Syntax

=TAN(number)
Argument What it means
number Radians.

Examples

Example 1

=B2*TAN(RADIANS(C2))

Height of a building from distance and viewing angle.

ATAN · SIN · RADIANS

📚 Part of the free Excel course: Beginner → Expert · Try it in the Formula Lab or ask the AI Helper.

Keep reading

Excel Functions A–ZLEFT Function in Excel: Take Characters From the Start of TextExcel Functions A–ZSIGN Function in Excel: Positive, Negative or Zero?Excel Functions A–ZCOMBIN Function in Excel: How Many Groups Are Possible
✨ Ask AI about this article

Stuck on a step? Ask a question and the AI answers using this article.

Free · AI can be wrong