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 the formatted string will be returned

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.

Read about Excel-VBA : INT() If the number is negative, and you want the first negative number less than equal to the given number.

Format:

VBA Function : FIX (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.

Read about Excel-VBA : FIX() If the number is negative, and you want the first negative number greater than equal to the given number.

Format:

VBA Function : INT(number)

Excel Formula : INT(number)

Arguments:

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. Blank spaces are not considered as non-numeric character.

Format:

VBA Function : VAL(string)

Arguments:

• Number
• Mandatory
• Type: String
• String from which the number needs to be extracted.

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 is SIGN().

Format:

As VBA Function : SGN(number)

As Excel Formula : SIGN(number)

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 it Formula-ROUND()

Format:

As VBA Function : ROUND(number, [decimal places])

Note : If you don’t provide the decimal places the function will consider it as 0 and returns the Integer.

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