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 gkittelson 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
Jeez is everyone on vacation?
I guess i can try to answer this
Use the Modulus function,
=1523 mod 60
this will give you the remainder but not
the quotient.
Jim
 
Upvote 0 Downvote
Hi Jim!

Try this: 1523 \ 60.

The backslash will give you integer division.

hth
Jeff Bridgham
bridgham@purdue.edu
 
Upvote 0 Downvote
DannyB2
Hello again,
try
=Int(1523/60) & " R" & 1523 Mod 60
Jim
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

TrekBiker
  • Locked
  • Question
Output To fails when name contains forward slash 1
Replies
7
Views
235
TrekBiker
TrekBiker
Dophia
  • Locked
  • Question
Form closing when another form opens 1
Replies
4
Views
164
dhookom
dhookom
N2Life
  • Locked
  • Question
Last figure in a text box is partially cut off when conditionally formatted as italics 1
Replies
7
Views
189
N2Life
N2Life
lmcate
  • Locked
  • Question
.laccdb file will not close on the server when I close the program???
Replies
1
Views
220
Andrzejek
Andrzejek
monkeysee
  • Locked
  • Question
Yes and No Check Box - Highlight when checked 1
Replies
8
Views
328
monkeysee
monkeysee

Part and Inventory Search

Sponsor

Back
Top