@TutorialHorizon
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:
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:
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:
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:
Description:
The TAN function in MS excel returns the tangent angle of a number.
Format:
Tan(number)
Arguments:
Description:
The Sin function in MS excel returns the sine angle of a number.
Format:
Sin(number)
Arguments:
Description:
The Cos function in MS excel returns the cosine angle of a number.
Format:
COS(number)
Arguments:
Description:
The Atn function in MS excel returns the arctangent of a number.
Format:
Atn(number)
Arguments:
Description:
The Abs function in MS excel returns the absolute value of a number.
Format:
Abs(number)
Arguments: