Excel Made Easy

Vba math functions in Excel

Though its possible to perform basic arithmetic calculations using the arithmetic operators discussed before, there are some occasions,

when there is a need to perform more complicated mathematical operations.Here is where, The built-in Math functions of VBA comes to help.

The most common Math functions are as discussed below

1.Abs() function

This function returns the absolute value, that is, positive value of the given number.

2.Exp() funtion

This function returns the exponential of a given number.

3.Int() and Fix() function

These functions are used to truncate decimal part of the given number and return an integer.

The diffrence between Int() and Fix() is that, when the number is negative, the Fix() function

returns the smallest number larger than the integer.

4.Rnd()

This function is used to generate a random value which lies between 0 and 1.

This function is useful with projects dealing with Probability.

The following example illustrates the above functions

The screenshot:

Output:

You can find similar Excel Questions and Answer hereunder

1) How to convert a number or string into a data with the cdate function

2) Is there a way I can round the sales figure to the nearest 500?

3) What is a module in VBA. How to create a module in VBA

4) How to modify strings in VBA, what are the functions you can manipulate strings with

5) What are the date and time function in Excel VBA

6) What is a function in VBA. How to create a function and how to call a function

7) How to format variable with VBA with the very useful format function. Define the number of decimal, the way a date is formated

8) How can worksheet functions be accessed in VBA?

9) What is variable scope in VBA, how do variable can be reach from other function or routines in VBA

10) Here we show you advanced VBA array functions, like splitting arrays, Lbound, Ubound