# Category: Math Functions

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

Description: The FORMAT() function in MS excel takes a number and returns it as formatted string based on specified parameter. Format: VBA Function : FORMAT (number,[format]) Arguments: Number Mandatory Type: number number for which...

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

Description: The FIX() function in MS excel returns the Integer part of a number NOTE: If the number is negative, FIX() will return the first negative number greater than equal to the given number....

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

Description: The INT() function in MS excel returns the Integer part of a number NOTE: If the number is negative, INT() will return the first negative number less than equal to the given number....

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

Excel-VBA : Math Functions – VAL() Description: The VAL function in MS excel returns the number found in the input string NOTE: This function stops reading the string when it finds first non-numeric charater....

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

Description: The SGN()/SIGN function in MS excel returns the Sign of a number NOTE: This function has different names, when used as VBA function it is SGN() and when used as Excel formula it...

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

Description: The ROUND function in MS excel returns a rounded number based on the specified number of digits. Note : ROUND() works slightly diffrent when used as Excel formula, Click here to know about...

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

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

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

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