+ for additions
- for subtractions
* for multiplications and
/ for divisions
but VBA has a fifth operand that you rarely see in published code:-
\ for division with integer result.
Such,
- Code: Select all
10/3 = 3.3333333
10\3 = 3
INT(10/3) = 3
Using the backslash operand is faster than the INT() function for the simple reason that it carries out a single calculation where the function has two.
Unfortunatley, the fifth operand isn't available in Excel. So, you can't enjoy its ease and simplicity in a worksheet.