Formulas > =TAN()

How To Use TAN() Function in Google Sheets


Returns the tangent of an angle provided in radians.
Common questions about the TAN formula:
-What does TAN stand for?
-What is the purpose of the TAN formula?
-How do you use the TAN formula correctly?

How can the TAN formula be used appropriately:
-The TAN formula can be used to take the tangent of a given angle in radians.

How can the TAN formula be commonly mistyped:
-TAN formula is commonly mistyped as TANG instead of TAN.

What are some common ways the TAN formula is used inappropriately:
-Using the TAN formula to calculate the tangent of a angle in degrees instead of radians.
-Trying to calculate the angle from the tangent value using the TAN formula.

What are some common pitfalls when using the TAN formula:
-Incorrectly inputting the number of radians
-Entering a number instead of an angle as an input

What are common mistakes when using the TAN formula:
-Using the wrong units.
-Using the formula to calculate the tangent of an angle in degrees.

What are common misconceptions people might have with the TAN Formula:
-Thinking that the TAN formula can be used to find the angle from a tangent value. 
-Thinking that the TAN formula works with angles in degrees instead of radians.

How To Actually Use TAN() in Sheets


Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at

Learn more about the TAN() formula:

Graphing Trigonometry Functions in Google Sheets

How to graph sine, cosine, and tangent in the spreadsheet program, Google Sheets. Create a t bar of angles in degrees, convert those angles to radians and create a chart to show the graph. Good introduction exercise to trig graphing.

Generate a TAN() formula for your needs with AI

Google Sheets Formula Generator

Whatever you need to do in sheets, you can generate a formula. Use the Better Sheets Formula generator to create a formula for any need. Completely free for members. Free to try for non-members.


Looking for more help inside sheets get the free Add-on: Asa. Ask Sheets Anything. Go ahead, ask it any problem you migth have. Bring your own APIKEY and generate formulas inside of Google Sheets.