FormulaCraft

TAN

TAN returns the tangent of an angle measured in radians (sine divided by cosine). Use =TAN(RADIANS(angle)) when working in degrees. The function is undefined at 90° and 270° where cosine is zero, so avoid those exact inputs.

Excel
=TAN(RADIANS(A2))
Google Sheets
=TAN(RADIANS(A2))
✓

Verified example

Computed by a real spreadsheet engine on the sample data below.

Angle (degrees)Tangent
0
45
30
60

=TAN(RADIANS(A2))→0

Try it with your data

Edit the grid or formula, then run it through a real spreadsheet engine — no signup.

Sample data — click any cell to edit

Runs server-side · free · no signup

How it works

  1. 1A2 contains the angle in degrees (e.g. 45).
  2. 2RADIANS(A2) converts degrees to radians before TAN evaluates.
  3. 3TAN(RADIANS(45)) = 1 because tan(45°) = sin(45°)/cos(45°) = 1.

Need a version for your data?

Try: “Calculate the tangent of angles from my degree list”

Related

SUMIFSUMIFSCOUNTIF

Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.

Last reviewed: