## 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 the formatted string will be returned

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

Read about Excel-VBA : INT() If the number is negative, and you want the first negative number less than equal to the given number.

Format:

VBA Function : FIX (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.

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:

## 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. Blank spaces are not considered as non-numeric character.

Format:

VBA Function : VAL(string)

Arguments:

• Number
• Mandatory
• Type: String
• String from which the number needs to be extracted.

## 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 is SIGN().

Format:

As VBA Function : SGN(number)

As Excel Formula : SIGN(number)

## 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 it Formula-ROUND()

`Format:`

As VBA Function : ROUND(number, [decimal places])

Note : If you don’t provide the decimal places the function will consider it as 0 and returns the Integer.

`Arguments:`

## 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
• Mandatory
• Type: Numbers
• Random number gets generated between these two numbers (Max – the highest value the random number can be. Min – The smallest value the random number can be)

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

`Format:`

As VBA Function : LOG(number) , default base is e = 2.71828183

In WorkSheet : LOG(number, [base])

`Arguments:`

## 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 for which e power needs to be calculated

## 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
• Type: Date
• Date, whose Week Date need to be calculated.

## 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, whose Month need to be calculated.

## 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 where you have to work with all the business working days. Example: If the date range is mentioned between 8-Jan-2014 to … Read more

## 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 act as any other built-in formula in excel , Which is one of the powerful  feature of Excel.

Like other formulas, you can apply your function in each cell or range of cells.

`Syntax:`

Public Function functionName (Arg As dataType,……….) As dataType

or

Private Function functionName (Arg As dataType,……….) As dataType

Arg As dataType -> data type of argument

The second data type is the return type of function.

Public : The function is applicable to the whole project.