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