Excel- VBA/Formula: Math Functions – TAN()

Description: 

The TAN function in MS excel returns the tangent angle of a number.

Format:

Tan(number)

Arguments:

• Number
  • Mandatory
  • Type: Number
  • Number for which tangent angle needs to be calculated

Example:

Function getTAN()

   Dim number1

   Dim number2

   number1 = 90

   number2 = 100

   MsgBox "The Tangent angles are " & Tan(number1) & " and " & Tan(number2)

End Function

Using Tan() as Excel Formula