# Tagged: Functions and Formulas

## ROUND()">Excel-Formula: Math Formula – ROUND()

Descrip­tion: The ROUND func­tion in MS excel returns a rounded num­ber based on the spec­i­fied num­ber of dig­its. For­mat: As Excel For­mula : ROUND(number,digits) Note : ROUND() works slightly diffrent when used as VBA

## RND()">Excel-VBA: Math Functions – RND()

Descrip­tion: The RND func­tion in MS excel returns the ran­dom num­ber gen­er­ated between two spec­i­fied ranges. For­mat: As VBA Func­tion : Int((Max — Min + 1) * Rnd + Min) Argu­ments: Max and Min Manda­tory Type:…

## VBA/Formula: Math Functions – LOG()">Excel– VBA/Formula: Math Functions – LOG()

Descrip­tion: The LOG func­tion in MS excel returns the log­a­rithm of a num­ber to the given base. NOTE: LOG func­tion takes dif­fer­ent para­me­ters when it is used in Work­Sheet and used as a VBA function.…

## VBA/Formula: Math Functions – EXP()">Excel– VBA/Formula: Math Functions – EXP()

Descrip­tion: The EXP func­tion in MS excel returns the e raised to the of a num­ber, where e is 2.71828183. Where e is called Euler’s Num­ber. For­mat: EXP(num­ber) Argu­ments: Num­ber Manda­tory Type: Num­ber Number…

## VBA/Formula: Math Functions – TAN()">Excel– VBA/Formula: Math Functions – TAN()

Descrip­tion: The TAN func­tion in MS excel returns the tan­gent angle of a num­ber. For­mat: Tan(num­ber) Argu­ments: Num­ber Manda­tory Type: Num­ber Num­ber for which tan­gent angle needs to be calculated

## VBA/Formula: Math Functions – Sin()">Excel– VBA/Formula: Math Functions – Sin()

Descrip­tion: The Sin func­tion in MS excel returns the sine angle of a num­ber. For­mat: Sin(num­ber) Argu­ments: Num­ber Manda­tory Type: Num­ber Num­ber for which sine angle needs to be calculated.

## VBA/Formula Math Functions – Cos()">Excel– VBA/Formula Math Functions – Cos()

Descrip­tion: The Cos func­tion in MS excel returns the cosine angle of a num­ber. For­mat: COS(num­ber) Argu­ments: Num­ber Manda­tory Type: Num­ber Num­ber for which cosine angle needs to be calculated

## VBA-Excel: Math Functions – Atn()

Descrip­tion: The Atn func­tion in MS excel returns the arc­t­an­gent of a num­ber. For­mat: Atn(num­ber) Argu­ments: Num­ber Manda­tory Type: Num­ber Num­ber for which arc­t­an­gent needs to be calculated

## VBA/Formula: Math Functions – Abs()">Excel– VBA/Formula: Math Functions – Abs()

Descrip­tion: The Abs func­tion in MS excel returns the absolute value of a num­ber. For­mat: Abs(num­ber) Argu­ments: Num­ber Manda­tory Type: Num­ber Num­ber for which absolute value needs to be calculated