# Category: Functions

## Excel-VBA : Math Functions – FORMAT()

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: Number Mandatory Type: number number for which...

## Excel-VBA : Math Functions – FIX()

Description: The FIX() function in MS excel returns the Integer part of a number NOTE: If the number is negative, FIX() will return the first negative number greater than equal to the given number....

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

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

## Excel-VBA : Math Functions – VAL()

Excel-VBA : Math Functions – VAL() Description: The VAL function in MS excel returns the number found in the input string NOTE: This function stops reading the string when it finds first non-numeric charater....

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

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

## Excel-VBA: Math Functions – ROUND()

Description: The ROUND function in MS excel returns a rounded number based on the specified number of digits. Note : ROUND() works slightly diffrent when used as Excel formula, Click here to know about...

## Excel-VBA: Math Functions – RND()

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: Max and Min...

## Excel- VBA/Formula: Math Functions – LOG()

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

## Excel- VBA/Formula: Math Functions – EXP()

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: Number Mandatory Type: Number Number...

## Excel- VBA/Formula: Math Functions – TAN()

Description: The TAN function in MS excel returns the tangent angle of a number. Format: Tan(number) Arguments: Number Mandatory Type: Number Number for which tangent angle needs to be calculated

## Excel- VBA/Formula: Math Functions – Sin()

Description: The Sin function in MS excel returns the sine angle of a number. Format: Sin(number) Arguments: Number Mandatory Type: Number Number for which sine angle needs to be calculated.

## Excel- VBA/Formula Math Functions – Cos()

Description: The Cos function in MS excel returns the cosine angle of a number. Format: COS(number) Arguments: Number Mandatory Type: Number Number for which cosine angle needs to be calculated

## VBA-Excel: Math Functions – Atn()

Description: The Atn function in MS excel returns the arctangent of a number. Format: Atn(number) Arguments: Number Mandatory Type: Number Number for which arctangent needs to be calculated

## Excel- VBA/Formula: Math Functions – Abs()

Description: The Abs function in MS excel returns the absolute value of a number. Format: Abs(number) Arguments: Number Mandatory Type: Number Number for which absolute value needs to be calculated

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

Description:          The Timer() function returns the Number of seconds and MiliSeconds since 12:00 AM. Format:           Timer() Example:

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

TimeSerial() Description: The TimeSerial() function returns the Time type based on the parameters provided (Hours, Minutes and Seconds). Format: DateSerial(Hour,Minutes,Seconds) Arguments: Hour Manda­tory Type: Numeric or Any Numeric Expression Between 0 and 23

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

WeekDay() Description: The WeekDay function takes Date as a parameter and returns a number between 1 and 7, that is the week day of the date provided. Format: WeekDay (strDate [Firstdayofweek]) Arguments: strDate Manda­tory...

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

Month() Description: The Month function takes Date as a parameter and returns a number between 1 and 12, that is the month of the date provided. Format: Month(strDate) Arguments: strDate Manda­tory Type: Date Date,...

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

This tutorial will teach you how to get all the working days or weekdays in a specified date range(excluding Satudays and Sundays), simple but very useful when you have come up with a excel...

## VBA-Excel: User Define Functions

Microsoft Excel has lot of built in formulas like Sin(), Avg() and many more, which we discuss in detail in future articles, but apart from that you can write your own functions which will...