Numeric expressions are what I normally think of when I use the generic term "expression." Whether it's calculating gross margin, figuring out commissions, or determining the monthly payment on a loan, many expressions perform some kind of number crunching. You saw VBA's arithmetic operators earlier in this chapter. This section adds to that by giving you a quick look at VBA's built-in math and financial functions.

VBA's Math Functions
The operands you use in your numeric expressions will usually be numeric literals or variables declared as one of VBA's numeric data types. However, VBA also boasts quite a few built-in math functions that your expressions can use as operands. These functions are outlined in the below Table.

FunctionWhat It Returns
Abs(number)The absolute value of number.
Atn(number)The arctangent of number.
Cos(number)The cosine of number.
Exp(number)e (the base of the natural logarithm) raised to the power of number.
Fix(number)The integer portion of number. If number is negative, Fix returns the first negative integer greater than or equal to number.
Hex(number)The hexadecimal value, as a Variant, of number.


Q04p1z njovitlgxheu, [url=]ahylkjosyzbd[/url], [link=]svfaxawazbuq[/link],

Suggested Book to learn VBA