# Category: 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

## VBA-Excel: Date-Time Functions — Timer()

Descrip­tion:          The Timer() func­tion returns the Num­ber of sec­onds and MiliSec­onds since 12:00 AM. For­mat:           Timer() Example:

## VBA-Excel: Date-Time Functions – TimeSerial() and TimeValue()

Time­Se­r­ial() Descrip­tion: The Time­Se­r­ial() func­tion returns the Time type based on the para­me­ters pro­vided (Hours, Min­utes and Sec­onds). For­mat: DateSerial(Hour,Minutes,Seconds) Argu­ments: Hour Manda­tory Type: Numeric or Any Numeric Expres­sion Between 0 and 23

## VBA-Excel: Date-Time Functions – WeekDay() and WeekDayName()

Week­Day() Descrip­tion: The Week­Day func­tion takes Date as a para­me­ter and returns a num­ber between 1 and 7, that is the week day of the date pro­vided. For­mat: Week­Day (str­Date [First­day­ofweek]) Argu­ments: str­Date Mandatory…

## VBA-Excel: Date-Time Functions – Month(), Year() and MonthName()

Month() Descrip­tion: The Month func­tion takes Date as a para­me­ter and returns a num­ber between 1 and 12, that is the month of the date pro­vided. For­mat: Month(strDate) Argu­ments: str­Date Manda­tory Type: Date Date,…

## VBA-Excel: Get all the WeekDays or Working days in Specified Date Range, (excluding Satudays and Sundays)

This tuto­r­ial will teach you how to get all the work­ing days or week­days in a spec­i­fied date range(excluding Sat­u­days and Sun­days), sim­ple but very use­ful when you have come up with a excel…

## VBA-Excel: User Define Functions

Microsoft Excel has lot of built in for­mu­las like Sin(), Avg() and many more, which we dis­cuss in detail in future arti­cles, but apart from that you can write your own func­tions which will…