Skip to content
Google Sheets

TAN function in Google Sheets

Returns the tangent of an angle provided in radians.

=TAN(angle)

TAN syntax and parameters

One argument, one required.

  • anglenumberRequired

    The angle to find the tangent of, in radians.

TAN examples

Formulas you'll actually reuse.

  1. Tangent of 45° — convert degrees first, trig functions take radians:

    =TAN(RADIANS(45))

    Result1

  2. Tangent of PI()/3 radians:

    =TAN(PI()/3)

    Result1.7321

TAN in Excel

Same name — your formula ports as-is.

Try TAN in the playground

Edit the example — nothing to install.

Preloaded with the TAN formula from Example 1 — change anything and watch it respond.

Loading the editor…