Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Remainders When Dividing?

Status
Not open for further replies.
Dannybe2

Dannybe2

Programmer
Jan 31, 2001
136
GB
How do I divide a number by another and create a remainder:

Eg.
1523 / 60 = 25.3833333
1523 / 60 = 25 R23
 
Sort by date Sort by votes
Hi,
Use the Mod function
Code: 
    a = 1523
    b = 60
    MsgBox a Mod b
Skip,
metzgsk@voughtaircraft.com
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

morechocolate
  • Locked
  • Question
run-tune error 3704 operation is not allowed when the object is codes: I don't think so.
Replies
7
Views
607
morechocolate
morechocolate
JTBorton
  • Locked
  • Question
Determine when a userform is closes without the Terminate event 1
Replies
6
Views
417
JTBorton
JTBorton
MattGreer
  • Locked
  • Question
How to ignore errors when Type Library is missing? 1
Replies
3
Views
153
MattGreer
MattGreer
Nikola Tesla
  • Locked
  • Question
Run-time error '-2147467259 (80004005)' A timeout occured when obtaining conversation results
Replies
1
Views
106
strongm
strongm
telephoto
  • Locked
  • Question
If...Then routine not recognised when it should be 1
Replies
12
Views
204
SkipVought
S

Part and Inventory Search

Sponsor

Back
Top