{"id":2880,"date":"2017-10-11T00:33:48","date_gmt":"2017-10-11T00:33:48","guid":{"rendered":"http:\/\/excelvbatutor.com\/?page_id=2880"},"modified":"2020-04-23T11:01:24","modified_gmt":"2020-04-23T11:01:24","slug":"excel-vba-lesson-6-mathematical-functions","status":"publish","type":"page","link":"https:\/\/excelvbatutor.com\/index.php\/excel-vba-lesson-6-mathematical-functions\/","title":{"rendered":"Excel VBA Lesson 6: Mathematical Functions"},"content":{"rendered":"

<<Lesson 5>><\/a> [Contents] <\/a><<Lesson 7>><\/a><\/strong><\/h4>\n

In Excel VBA macro programming, we can write codes that can perform arithmetic operations using standard arithmetic operators.
\nHowever, for more complex mathematical calculations, we need to use the built-in mathematical functions in Excel VBA.<\/p>\n

There are numerous built-in mathematical functions in Excel VBA.
\nAmong them are Abs, Exp, Int, Fix, Rnd, Round, sqr and more. We shall deal with trigonometric functions and Financial Functions in coming lessons.<\/p>\n

6.1 The Abs Function<\/h3>\n

In Excel VBA, the Abs function returns the absolute value(positive value) of a given number.
\nThe syntax is<\/p>\n

Abs(Number)<\/p>\n

Example 6.1<\/h4>\n

Private Sub CommandButton1_Click()<\/p>\n

Cells(1,1)=Abs(-100)<\/p>\n

End Sub<\/p>\n

Running the program will display 100 in cell A1<\/p>\n