When would I actually use TAN in a spreadsheet?

TAN is designed for trigonometric calculations—modeling angles in physics, engineering, geometry, or surveying contexts. In typical business or academic spreadsheets like gradebooks, you rarely need it unless you're intentionally designing angle-based metrics or slope calculations.

Why does TAN(1.5707) return a giant number?

1.5707 is extremely close to π/2 (≈1.5708), where tangent is mathematically undefined and approaches infinity. Spreadsheets return a very large number due to floating-point precision limits rather than true infinity. To avoid this, stay away from angles near π/2, 3π/2, and other odd multiples of π/2.

Can TAN work with negative angles?

Yes. TAN follows the identity TAN(–x) = –TAN(x), so negative angles produce negative tangent values. This property is useful for modeling directional or symmetric angle relationships.

What's the difference between TAN and other math functions like SIN or COS?

TAN specifically calculates the ratio of opposite to adjacent (sine divided by cosine), while SIN and COS measure individual sides of a right triangle. TAN grows much more rapidly as angles approach π/2, making it useful for modeling steep relationships.

TAN function

TAN returns the tangent of an angle in radians, calculating the ratio of the opposite side to the adjacent side in a right triangle.

=TAN(number)

Generate a TAN formula

Describe what you need. The generator will reach for TAN where TAN is the right tool, and tell you when it is not.

Arguments

How TAN reads its arguments

Argument	Required	Description
number	Required	The angle in radians (not degrees). Accepts positive or negative values; tangent approaches infinity as the angle nears odd multiples of π/2 (1.57, 4.71, etc.).

Returns

A decimal number representing the tangent of the input angle in radians.

Availability

Excel: All · Google Sheets: Supported

Worked examples

1. Calculate steepness of assignment difficulty angle

Student	Subject	Assignment	Score	Max
Alice	Math	Quiz 1	85	100
Bob	Math	Quiz 1	92	100

=TAN(1.5)

Result: 14.1014

If assignment difficulty is modeled as 1.5 radians, TAN(1.5) ≈ 14.1 represents the angle's steepness—how sharply the opposite-to-adjacent ratio grows. This metric could indicate how steeply performance expectations increase with that difficulty level.

2. Find tangent of student score ratio angle

Student	Subject	Assignment	Score	Max
Alice	Math	Quiz 1	85	100
Bob	English	Essay	88	100

=TAN(0.85)

Result: 1.1356

Alice's Math score is 85/100 = 0.85. Interpreting 0.85 as a radian angle (approximately 48.7 degrees), TAN(0.85) ≈ 1.136 gives the tangent ratio for that normalized performance angle, showing the relationship between opposite and adjacent sides.

3. Model improvement rate from performance angle

Student	Subject	Assignment	Score	Max
Alice	Math	Quiz 1	85	100
Alice	Math	Quiz 2	92	100

=TAN(0.5)

Result: 0.5463

If Alice's score improvement from Quiz 1 to Quiz 2 is represented as a 0.5 radian angle, TAN(0.5) ≈ 0.546 measures the slope of that improvement. Smaller tangent values indicate gentler improvement curves; larger values indicate steeper progress.

Common errors

Which TAN error are you seeing?

Error	Why it happens	How to fix it
#VALUE!	The argument is text or a cell containing text rather than a number. For example, =TAN("0.5") or =TAN(A1) where A1 contains the word 'angle'.	Verify the argument is numeric. If it's stored in a cell, ensure that cell contains only a number, not text. Use VALUE(cell) to convert text-formatted numbers to actual numbers first.
#NUM!	The input number causes tangent to approach infinity or overflow the calculation. This occurs when the angle is very close to π/2 (≈1.5708), 3π/2 (≈4.7124), or other odd multiples of π/2 where tangent is mathematically undefined.	Use an angle that is not near π/2 plus any multiple of π. If you must work with angles near these values, use a slightly smaller or larger value, such as TAN(1.56) instead of TAN(1.5708).
#NAME?	The function name is misspelled or the function is not recognized in your spreadsheet application or regional language setting. Examples: =TANGENT(0.5), =Tan(0.5), or unsupported regional function names.	Use the exact function name =TAN(number) with capital letters. Check that your spreadsheet application supports TAN in your current language or region; some locales may use different function names.

Tips and when to use something else

TAN requires angles in radians, not degrees. To find the tangent of a degree-based angle, convert first using this formula: =TAN(RADIANS(degrees)).
TAN repeats every π radians—TAN(x) always equals TAN(x + π)—so you can use ABS and MOD to reduce large angles to a manageable range.
For typical gradebook work (score summaries, rankings, averages), use SUMIF, AVERAGE, or PERCENTILE instead. Reserve TAN for angle-based or trigonometric modeling scenarios only.
Pair TAN with ROUND or INT to control decimal places in the result, since tangent often returns many decimal places.

Related functions

ROUNDROUND returns a number rounded to a specified number of decimal places, using standard rounding rules (0.5 rounds up).ABSABS returns the absolute value of any number, removing the sign to show only magnitude, useful for comparing distances regardless of direction.INTINT rounds any number down to the nearest whole integer, always discarding decimal places and rounding toward negative infinity.IFThe IF function returns one value if a condition is true and another (or nothing) if it is false, letting you branch logic in a cell.

Frequently asked questions

When would I actually use TAN in a spreadsheet?: TAN is designed for trigonometric calculations—modeling angles in physics, engineering, geometry, or surveying contexts. In typical business or academic spreadsheets like gradebooks, you rarely need it unless you're intentionally designing angle-based metrics or slope calculations.
Why does TAN(1.5707) return a giant number?: 1.5707 is extremely close to π/2 (≈1.5708), where tangent is mathematically undefined and approaches infinity. Spreadsheets return a very large number due to floating-point precision limits rather than true infinity. To avoid this, stay away from angles near π/2, 3π/2, and other odd multiples of π/2.
Can TAN work with negative angles?: Yes. TAN follows the identity TAN(–x) = –TAN(x), so negative angles produce negative tangent values. This property is useful for modeling directional or symmetric angle relationships.
What's the difference between TAN and other math functions like SIN or COS?: TAN specifically calculates the ratio of opposite to adjacent (sine divided by cosine), while SIN and COS measure individual sides of a right triangle. TAN grows much more rapidly as angles approach π/2, making it useful for modeling steep relationships.

Need a different formula?

The full generator is not scoped to one function — describe any spreadsheet problem and it will pick.

Open the formula generator

Reviewed 2026-09-17