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

`Description: `

The ROUND function in MS excel returns a rounded number based on the specified number of digits.

`Format:`

As Excel Formula : ROUND(number,digits)

Note : ROUND() works slightly diffrent when used as VBA function.Click here to know about it VBA-ROUND()

`Arguments:`

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

`Description: `

The RND function in MS excel returns the random number generated between two specified ranges.

`Format:`

As VBA Function : Int((Max – Min + 1) * Rnd + Min)

`Arguments:`
• Max and Min
• Mandatory
• Type: Numbers
• Random number gets generated between these two numbers (Max – the highest value the random number can be. Min – The smallest value the random number can be)

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

`Description:`

The LOG function in MS excel returns the logarithm of a number to the given base.

NOTE: LOG function takes different parameters when it is used in WorkSheet and used as a VBA function.

`Format:`

As VBA Function : LOG(number) , default base is e = 2.71828183

In WorkSheet : LOG(number, [base])

`Arguments:`

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

`Description:`

The EXP function in MS excel returns the e raised to the of a number, where e is 2.71828183.

Where e is called Euler’s Number.

`Format:`

EXP(number)

`Arguments:`
• Number
• Mandatory
• Type: Number
• Number for which e power needs to be calculated

## 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

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

`Description: `

The Sin function in MS excel returns the sine angle of a number.

`Format:`

Sin(number)

`Arguments:`
• Number
• Mandatory
• Type: Number
• Number for which sine angle needs to be calculated.

## Excel- VBA/Formula Math Functions – Cos()

`Description: `

The Cos function in MS excel returns the cosine angle of a number.

`Format:`

COS(number)

`Arguments:`
• Number
• Mandatory
• Type: Number
• Number for which cosine angle needs to be calculated

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

`Description: `

The Atn function in MS excel returns the arctangent of a number.

`Format:`

Atn(number)

`Arguments:`
• Number
• Mandatory
• Type: Number
• Number for which arctangent needs to be calculated

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

`Description: `

The Abs function in MS excel returns the absolute value of a number.

`Format:`

Abs(number)

`Arguments:`
• Number
• Mandatory
• Type: Number
• Number for which absolute value needs to be calculated