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)

Read moreExcel-VBA : Math Functions – FIX()

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:

Read moreExcel-VBA/Formula : Math Functions – INT()

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:

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:

Read moreExcel-VBA: Math Functions – ROUND()

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)

    Read moreExcel-VBA: Math Functions – RND()

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:

Read moreExcel- VBA/Formula: Math Functions – LOG()