Good question. Excel VBA supports \ but if you want to do integer division in Excel (like in the cells) use the QUOTIENT function.

=QUOTIENT(10,3)

This returns 3.

You can also use the INT function to truncate the result of regular division:

=INT(10/3)

That also gives 3, but there's a difference. INT always rounds down toward negative infinity, while QUOTIENT just drops the remainder.

So if you're dividing negative numbers, INT(-10/3) gives -4, but QUOTIENT(-10,3) gives -3.

Use QUOTIENT if you want true integer division like VBA's \ operator.