Math & trig

TAN function

Tangent of an angle in radians. TAN works in Sheets with the usual arguments and results, on cells and on live data from the tools you connect.

Syntax

=TAN(number)

Argument	Use
`number`	required

On live data

In Sheets, TAN sits next to live data from a connected tool: =data.orders.sum(total) totals a table, =list.orders(customer) spills a column's distinct values, and a linked table column such as table.orders[Total] is a range any function accepts.

See the integrations

More math & trig functions

ROUNDRound to N decimals SUMSum of values SUMIFSum where one criterion matches SUMIFSConditional sum SUMPRODUCTSum of element-wise products ABSAbsolute value ACOSArccosine, in radians ACOSHInverse hyperbolic cosine ACOTArccotangent, in radians ACOTHInverse hyperbolic cotangent AGGREGATEAggregate that can skip error values ARABICRoman numerals as a number

All 84 math & trig functions →

Spreadsheet formulas on live business data

Sheets evaluates 491 spreadsheet functions, on cells and on data read live from your tools.

See the integrations