Category: Math Functions

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…

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

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

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

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

Excel-VBA : Math Func­tions – VAL() Descrip­tion: The VAL func­tion in MS excel returns the num­ber found in the input string NOTE: This func­tion stops read­ing the string when it finds first non-numeric charater. Blank…

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-VBA: Math Functions – 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. Note : ROUND() works slightly diffrent when used as Excel for­mula, Click here to know about…

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

Descrip­tion: The RND func­tion in MS excel returns the ran­dom num­ber gen­er­ated between two spec­i­fied ranges. For­mat: As VBA Func­tion : Int((Max — Min + 1) * Rnd + Min) Argu­ments: Max and Min Manda­tory Type:…

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-Excel: Math Functions – Atn()

Descrip­tion: The Atn func­tion in MS excel returns the arc­t­an­gent of a num­ber. For­mat: Atn(num­ber) Argu­ments: Num­ber Manda­tory Type: Num­ber Num­ber for which arc­t­an­gent 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