{"id":96522,"date":"2021-06-22T09:00:04","date_gmt":"2021-06-22T03:30:04","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=96522"},"modified":"2021-06-07T12:58:17","modified_gmt":"2021-06-07T07:28:17","slug":"vba-arithmetic-operators","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/vba-arithmetic-operators\/","title":{"rendered":"Arithmetic Operators – Visual Basic"},"content":{"rendered":"

VBA Arithmetic Operators perform operations such as adding, subtracting, multiplying and dividing the numbers. In these operations, we calculate the numeric values and they are represented by variables, functions, constants, property calls and other expressions.<\/span><\/p>\n

VBA Arithmetic Operators<\/h3>\n

Various VBA mathematical operators are:<\/span><\/p>\n\n\n\n\n\n\n\n\n\n\n
Operation<\/b><\/td>\nOperator<\/b><\/td>\nFormula<\/b><\/td>\nDescription<\/b><\/td>\n<\/tr>\n
Addition<\/span><\/td>\n+<\/span><\/td>\n=5+3<\/span><\/p>\n

=8<\/span><\/p>\n

\u00a0<\/span><\/td>\n

Summing of two or more values.<\/span><\/td>\n<\/tr>\n
Subtraction<\/span><\/td>\n–<\/span><\/td>\n=10-3<\/span><\/p>\n

=7<\/span><\/td>\n

Subtracting the values.<\/span><\/td>\n<\/tr>\n
Multiplication<\/span><\/td>\n*<\/span><\/td>\n=5*2<\/span><\/p>\n

=10<\/span><\/td>\n

Product of two values in the cells.<\/span><\/td>\n<\/tr>\n
Division<\/span><\/td>\n\/<\/span><\/td>\n=10\/2<\/span><\/p>\n

=5<\/span><\/td>\n

Dividing the value of a cell by another value in the cell.<\/span><\/td>\n<\/tr>\n
Exponentiation<\/span><\/td>\n^<\/span><\/td>\n=2^3<\/span><\/p>\n

=8<\/span><\/td>\n

Raising of the value by a power value.<\/span><\/td>\n<\/tr>\n
Negation<\/span><\/td>\n~<\/span><\/td>\na=2<\/span><\/p>\n

b=-a<\/span><\/p>\n

b=-2<\/span><\/td>\n

Negation applies on one number and it uses the subtraction operator.<\/span><\/td>\n<\/tr>\n
Modulus<\/span><\/td>\nmod<\/span><\/td>\n=11mod2<\/span><\/p>\n

=1<\/span><\/td>\n

Divides the\u00a0 number and returns the remainder.<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

VBA Arithmetic Operators Example<\/h3>\n

To perform arithmetic operations, follow the below steps:<\/span><\/p>\n

1: Open an excel workbook and save it as an excel macro-enabled workbook.\u00a0<\/span><\/p>\n

2: <\/span>\u00a0<\/b>Add a button using macros.\u00a0<\/span><\/p>\n

In order to create a macro,\u00a0<\/span><\/p>\n