Daily posts of Excel tips…and other stuff
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.
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.
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].
ross:
Oooch, I wouldn’t touch that with a rats tail.
23 October 2004, 10:38 amPeter:
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 pmRichard 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 pmDan:
Peter - You’re right this is forward slash - / and this is backslash \
21 May 2008, 3:37 amjohn:
I\’l be back… :)U
30 July 2008, 8:47 amChad Garrett:
Man, 4 years and the forward slash, back slash thing still isn’t corrected.
28 August 2008, 2:45 pm