Category: Formulas

FORMAT()">Excel-VBA : Math Functions – FORMAT()

Descrip­tion: The FORMAT() func­tion in MS excel takes a num­ber and returns it as for­mat­ted string based on spec­i­fied para­me­ter. For­mat: VBA Func­tion : FORMAT (number,[format]) Argu­ments: Num­ber Manda­tory Type: num­ber num­ber for which…

INT()">Excel-VBA/Formula : Math Functions – INT()

Descrip­tion: The INT() func­tion in MS excel returns the Inte­ger part of a num­ber NOTE: If the num­ber is neg­a­tive, INT() will return the first neg­a­tive num­ber less than equal to the given number.…

SGN/SIGN()">Excel-VBA/Formula : Math Functions – SGN/SIGN()

Descrip­tion: The SGN()/SIGN func­tion in MS excel returns the Sign of a num­ber NOTE: This func­tion has dif­fer­ent names, when used as VBA func­tion it is SGN() and when used as Excel for­mula it…

ROUND()">Excel-Formula: Math Formula – ROUND()

Descrip­tion: The ROUND func­tion in MS excel returns a rounded num­ber based on the spec­i­fied num­ber of dig­its. For­mat: As Excel For­mula : ROUND(number,digits) Note : ROUND() works slightly diffrent when used as VBA

VBA/Formula: Math Functions – LOG()">Excel– VBA/Formula: Math Functions – LOG()

Descrip­tion: The LOG func­tion in MS excel returns the log­a­rithm of a num­ber to the given base. NOTE: LOG func­tion takes dif­fer­ent para­me­ters when it is used in Work­Sheet and used as a VBA function.…

VBA/Formula: Math Functions – EXP()">Excel– VBA/Formula: Math Functions – EXP()

Descrip­tion: The EXP func­tion in MS excel returns the e raised to the of a num­ber, where e is 2.71828183. Where e is called Euler’s Num­ber. For­mat: EXP(num­ber) Argu­ments: Num­ber Manda­tory Type: Num­ber Number…

VBA/Formula: Math Functions – TAN()">Excel– VBA/Formula: Math Functions – TAN()

Descrip­tion: The TAN func­tion in MS excel returns the tan­gent angle of a num­ber. For­mat: Tan(num­ber) Argu­ments: Num­ber Manda­tory Type: Num­ber Num­ber for which tan­gent angle needs to be calculated

VBA/Formula: Math Functions – Sin()">Excel– VBA/Formula: Math Functions – Sin()

Descrip­tion: The Sin func­tion in MS excel returns the sine angle of a num­ber. For­mat: Sin(num­ber) Argu­ments: Num­ber Manda­tory Type: Num­ber Num­ber for which sine angle needs to be calculated.

VBA/Formula Math Functions – Cos()">Excel– VBA/Formula Math Functions – Cos()

Descrip­tion: The Cos func­tion in MS excel returns the cosine angle of a num­ber. For­mat: COS(num­ber) Argu­ments: Num­ber Manda­tory Type: Num­ber Num­ber for which cosine angle needs to be calculated

VBA/Formula: Math Functions – Abs()">Excel– VBA/Formula: Math Functions – Abs()

Descrip­tion: The Abs func­tion in MS excel returns the absolute value of a num­ber. For­mat: Abs(num­ber) Argu­ments: Num­ber Manda­tory Type: Num­ber Num­ber for which absolute value needs to be calculated