Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
What does "\" do in VBA
Hello,
I hope this is not a silly question. I was researching someones elses VBA project & noticed this line of code: row_d = a + (currentIndex - 1) \ 10 + currentIndex - 1 I know the "/" means divide by but what does the "\" do in this above equation, it doesn't mean divide as I tried that. Any help would be greatly appreciated. Thank you, Jeff |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
What does "\" do in VBA
It means integer divide. It disregards any fractional part of the
result. E.g., 8 \ 3 = 2 -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Jeff" wrote in message ... Hello, I hope this is not a silly question. I was researching someones elses VBA project & noticed this line of code: row_d = a + (currentIndex - 1) \ 10 + currentIndex - 1 I know the "/" means divide by but what does the "\" do in this above equation, it doesn't mean divide as I tried that. Any help would be greatly appreciated. Thank you, Jeff |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
What does "\" do in VBA
Chip Pearson wrote:
It means integer divide. It disregards any fractional part of the result. E.g., 8 \ 3 = 2 Before division is performed, the numeric expressions are rounded to Byte, Integer, or Long expressions. E.g., 8 \ 2.5 -------- 4 (it rounds the 2.5 to 2) 8 \ 2.6 -------- 3 (it rounds the 2.6 to 3) Alan Beban |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
correct syntax for nesting "if", "and", and "vlookup"....if possib | Excel Worksheet Functions | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel |