EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 120+ Courses All in One Bundle
  • Login
Home Excel Excel Resources Maths Function in Excel Excel TAN Function
Secondary Sidebar
Excel Functions
  • Maths Function in Excel
    • Calculating Investment Return In Excel
    • Sumif Function Examples
    • MROUND in Excel
    • SUM Cells in Excel
    • MMULT in Excel
    • MINVERSE in Excel
    • Trunc in Excel
    • SUMIF with Text
    • COS Function in Excel
    • RANDBETWEEN in Excel
    • Excel SUMIF with OR
    • Excel DEGREES Function
    • Calculations in Excel
    • Sumif Between Two Dates
    • Calculate Income Tax in Excel
    • PRODUCT Function in Excel
    • How to Sum Multiple Rows in Excel
    • Matrix in Excel
    • ROUND Formula in Excel
    • How to SUM in Excel
    • SUMPRODUCT Formula in Excel
    • Excel Running Total
    • Excel Rounding
    • Excel Exponents
    • Excel SIN Function
    • Excel Square Root Function
    • Excel ROUNDUP Function
    • ROUND Excel Function
    • Excel ROUNDDOWN Function
    • ODD Excel Function
    • SUMPRODUCT Function in Excel
    • AGGREGATE Function in Excel
    • ABS Function in Excel
    • Excel TAN Function
    • COMBIN Function in Excel
    • CEILING Function in Excel
    • INT Excel Function
    • SUBTOTAL Function in Excel
    • LN Function in Excel
    • Excel RAND Function
    • TANH Function in Excel
    • SUMIF Function in Excel
    • SUM Function in Excel
    • POWER Function in Excel
    • EVEN Function in Excel
    • LOG Function in Excel
    • FLOOR Excel Function
  • Excel Functions (12+)
  • Excel Tools (114+)
  • Financial Functions in Excel (17+)
  • Logical Functions in Excel (14+)
  • Lookup Reference Functions in Excel (35+)
  • TEXT and String Functions in Excel (26+)
  • Date and Time Function in Excel (24+)
  • Statistical Functions in Excel (59+)
  • Information Functions in Excel (4+)
  • Excel Charts (56+)
  • Excel Tips (222+)
  • Workplace Productivity (4+)
  • Microsoft Office Tools (15+)
  • Excel Formula and Functions (22+)
  • MS Excel Shortcuts (4+)
Excel Functions Courses
  • Online EXCEL ADVANCED Certification
  • Excel for HR Training

Excel TAN Function

By Madhuri ThakurMadhuri Thakur

TAN in Excel

TAN Function in Excel (Table of Contents)

  • TAN in Excel
  • How to Use TAN Function in Excel?

Introduction to TAN in Excel

Tan Function in Excel is another mathematical trigonometry function used to calculate tan value at any angle. In mathematics, Tan is the ratio of Perpendicular by Base and by this, we get tangent value at any angle. If we want to convert any angle first, we need to RADIANS function or Pi()/4 to get the actual Tan value.

Start Your Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

TAN Function in Excel

The actual meaning of TAN is TANGENT. It is one of the Trigonometric functions like COS, SIN etc. TANGENT is based on a right-angle triangle. With the help of this function, it is much easier to find the tangent if we compare it with doing manually. The only thing is that we have to first find RADIANS for the given angle, then only we can easily calculate TANGENT.

All the required angle must be in Radians.

All in One Excel VBA Bundle(120+ Courses, 30+ Projects)
Basic ExcelAdvanced ExcelVBA & MacrosExcel Dashboards
Pivot TablesStatistical FunctionsFinancial FunctionsCharts & Graphs
Price
View Courses
120+ Online Courses | 30+ Projects | 500+ Hours | Verifiable Certificates | Lifetime Access
4.9 (64,452 ratings)

There are two ways by which we can find Radians for the given angle:

  1. Using the RADIANS function inside the TAN function, or first, we can use the RADIANS function on the degrees and then find the TAN from Radians. Below are calculations in Microsoft Excel in both ways:

TAN 1

OR

TAN 2

  1. We can also convert it in Radians by using the PI function, which is as: degrees * PI()/180. Below is the Excel calculation of the TAN function:

TAN 3

The TANGENT function used in our real life as well. TANGENT is used in architectures where the calculation of length and height is required for the geometric figures. It is also used in aeronautics, navigation system, engineering, roofing, many trigonometric applications, GPS, etc. The pilot mostly used the TANGENT function to calculate the distance from the ground for landing & safety purpose.

  • The TANGENT function returns the tangent of an angle, and it will always be in numeric.

In Mathematics, the formula will be TAN 0 = opposite side/adjacent side

TAN Diagram

So, from the above pic, we can say c = a/b

TAN Formula

Below is the TAN Formula:

TAN Formula

Parameters or Arguments:

Number: it is the number or numeric value for which tangent needs to be calculated of an angle.

Result: TAN function always returns the numeric value after applying to a particular cell.

Type:

  • Worksheet function
  • VBA function

Hence, the TAN function can be used in two ways, i.e. worksheet function in which the formula of TAN function needs to be entered in a particular cell of the worksheet to find the Tangent, and we can also use the TAN function in VBA, and we have to write the formula in Microsoft Visual Basic Editor.

How to Use TAN Function in Excel?

TAN Function is very simple to use. Let us now see how to use the TAN function in Excel with the help of some examples.

You can download this TAN function Excel Template here – TAN function Excel Template

Example #1

For calculating tangent, we have to calculate Radians so that we can have the correct data or output.

Step 1: We have to check the raw data for which we have to calculate the tangent and verify them; below is the picture:

Example 1-1

Step 2: Then click on the Formulas in the ribbon of Microsoft Excel, and then we have to click on Math & Trig. Below is the picture for reference:

Example 1-2

Step 3: Now, we have to apply the Radians formula from the list available. So, just find RADIANS and click it as given in the below picture:

TAN Example 1-3

Step 4: After clicking we have like below the screen, then put the cell address or just select it from the cursor for which RADIANS need to be calculated:

TAN Example 1-4

So, in this case, the cell address is B5, for which RADIANS have to be calculated.

Step 5: After selecting the cell address, we have to just click on OK or press enter; the result will be RADIANS of the given angle.

TAN Example 1-5

Then, we can drag the formula in all the required cells to find out the RADIANS. Below is the result:

TAN Example 1-5-1

Step 6: Now, we have to calculate the TANGENT to follow steps 2 & 3 and then look for TAN and click it. Below is the picture for reference:

TAN Example 1-6

Step 7: Now we have to select the cell address for which TANGENT needs to be calculated, so as we know, we have to select the radians of a given angle, then, in this case, we will select the cell address C5, as the argument or parameter. Below is the picture for reference:

TAN Example 1-7

Step 8: Now, we can click ok press Enter to get the results

TAN Example 1-8

, and we can drag the TAN formula to another required cell as well, like below:

TAN Example 1-8-1

So, we saw above that how to calculate TANGENT by using the TAN function in Excel.

Example #2

By putting formula

We can also calculate TANGENT by using the formula or entering the formula of TAN in the required cell. Below is the formula:

=TAN(number)

Step 1: Firstly, we should have Radians ready for the required angle, which we have seen above, that how to calculate in step 3 to 5, which has a formula of = RADIANS(angle).

Example 2-1

The Result will be:

Example 2-1-1

Step 2: Now, we can enter a TANGENT formula in the cell address E4, which is =TAN(number). So, we have to type =TAN and then tab key. Below is the screenshot for reference:

Example 2-2

Step 3: Now, we have to select the cell address of calculated radians, which is D4 in the given an example, in the place of number as argument or parameter. Below is the picture for reference:

Example 2-3

Step 4: After putting the number, we have to just close the bracket to complete the formula or press enter; both have the same result. Below is the picture:

TAN Example 2-4

Step 5: We have the required calculated result of TANGENT after following the above steps. Below is the result in the picture:

TAN Example 2-5

TAN Function in VBA:

As we discussed above, that TAN function can also be used in VBA code, so we can take one example to see how it works and what will be the input and procedure. Below is the VBA code to calculate Tangent:

DimLnumber As Double

LNmuber = Tan(5)

So, in the above example, the LNumber 5 contains the value of -3.380515006.

Things to Remember

  1. if the angle is given in degrees for which we have to calculate TAN, we have to calculate RADIANS for the same by using formula =RADIAN(degree), or we can multiply the angle by PI()/180.
  2. The TAN function always uses the parameter as RADIANS.
  3. If the TAN function has #VALUE! An error then it means that text is used in the place of a number.
  4. If the cell chooses as a blank cell in the place of a number, then the result would be 1 because the tangent is 1 for the radiant 0. So, always be careful while selecting a cell.

Recommended Articles

This has been a guide to the Excel TAN function. Here we discuss the TAN Formula and how to use the TAN function along with practical examples and a downloadable excel template. You can also go through our other suggested articles –

  1. RATE Function in Excel
  2. SUMIF in Excel
  3. SUBSTITUTE Function in Excel
  4. COS Function in Excel
Popular Course in this category
Excel Advanced Training (16 Courses, 23+ Projects)
  16 Online Courses |  23 Hands-on Projects |  140+ Hours |  Verifiable Certificate of Completion
4.8
Price

View Course

Related Courses

Excel for HR Training (8 Courses, 10+ Projects)4.9
3 Shares
Share
Tweet
Share
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Excel Charts
  • Excel Tips
  • All Tutorials
Certification Courses
  • All Courses
  • Excel VBA Course - All in One Bundle
  • VBA Course
  • Excel Data Analysis Course
  • Excel for Marketing Course
  • Excel for Finance Course
  • Excel for HR Training

ISO 10004:2018 & ISO 9001:2015 Certified

© 2022 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

Download TAN function Excel Template

EDUCBA

Download TAN function Excel Template

EDUCBA

डाउनलोड TAN function Excel Template

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more