Skip to content
Excel

TAN function in Excel

Returns the tangent of a number

=TAN(number)

TAN syntax and parameters

One argument, one required.

  • numbernumberRequired

    The angle in radians for which you want the tangent.

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 Google Sheets

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…

Related functions

More ways Excel gets this done.