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 func­tion in MS excel returns the tan­gent angle of a number.



  • Num­ber
    • Manda­tory
    • Type: Num­ber
    • Num­ber for which tan­gent 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 For­mula


You may also like...

Leave a Reply

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

%d bloggers like this: