@TutorialHorizon
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:
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:
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)
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 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 Abs function in MS excel returns the absolute value of a number.
Format:
Abs(number)
Arguments: