Show Buttons
Share On Facebook
Share On Twitter
Share On Google Plus
Share On Linkdin
Share On Reddit
Contact us
Hide Buttons

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


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



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


Function getTAN()

   Dim number1

   Dim number2

   number1 = 90

   number2 = 100

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

End Function
Tan() - Function

Tan() – Function

Using Tan() as Excel Formula

TAN Formula

TAN Formula


You may also like...

Leave a Reply

Your email address will not be published. Required fields are marked *

%d bloggers like this: