« Blog Readers Choice Awards
Determine If Cell is Hidden in VBA »

Integer Division

22nd October 2004, 09:49 am by Dick Kusleika

Just as the backslash (/) is the division operator, the forward slash () is the integer division operator. Use it when you need to divide numbers but require the result to be an integer.

Intdivision

Beware that the numbers are rounded before the division takes place. For that reason, I’ve never seen a need to use this operator with non-integer numbers.

Category: VBA Basics, VBA Functions and Keywords  |  Comment (RSS)

6 Comments

  1. ross:

    Oooch, I wouldn’t touch that with a rats tail.

    23 October 2004, 10:38 am

  2. Peter:

    I thought that tis was the backslash: \
    and this this the forward slash: / (into the reading direction)

    Then again, nothing surprises me nowadays, so if it turns out I’m wrong, so be it.

    Peter

    23 October 2004, 6:22 pm

  3. Richard Tallent:

    Also, note that integer division with “” is performed *after* normal division and multiplication, as I noted recently in my blog:

    http://www.tallent.us/blog/CommentView.aspx?guid=c41bd09e-2d2f-4a5c-a959-3062793c1bc3

    24 October 2004, 6:40 pm

  4. Dan:

    Peter - You’re right this is forward slash - / and this is backslash \

    21 May 2008, 3:37 am

  5. john:

    I\’l be back… :)U

    30 July 2008, 8:47 am

  6. Chad Garrett:

    Man, 4 years and the forward slash, back slash thing still isn’t corrected.

    28 August 2008, 2:45 pm

Certain comments are subject to moderation and may not appear immediately. You can use HTML tags in your comment. If you include a greater-than or less-than sign or anything else that could be interpreted as HTML, your comment won't look nice. You need to escape those characters. To post VBA code in your comment, use [VB] tags, like this: [VB]Code goes here[/VB].

Leave a comment