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 wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Math Stumper

Status
Not open for further replies.
SWarrior

SWarrior

MIS
Dec 19, 2003
111
US
I need to get the Remainder of a division answer.

For example, 48 / 7 = 6, remainder 6. Because 7 * 6 = 42 and then there is 6 left over. I need the 6.

51 / 7 = 7, remainder 2
and so on.

-SWarrior
 
Sort by date Sort by votes
Nevermind... worked it out this way...

Code: 
Remainder = F - (int(f/7)*7)

-SWarrior
 
Upvote 0 Downvote
There's a built in function for doing this:

Remainder = F [red]Mod[/red] 7

Lee
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

DeadHeat
  • Locked
  • Question
INSERT INTO stumper...
Replies
4
Views
83
jasonp45
jasonp45
starkid
  • Locked
  • Question
Have a logic Error Unable to do Math
Replies
1
Views
57
Frink
Frink
JadeKnight
  • Locked
  • Question
Mathematical equation for counter 1
Replies
3
Views
154
JadeKnight
JadeKnight
disord3r
  • Locked
  • Question
Math Problem
Replies
1
Views
52
JuanitaC
JuanitaC
mikecoal
  • Locked
  • Question
math formula generates overflow error
Replies
2
Views
103
mikecoal
mikecoal

Part and Inventory Search

Sponsor

Back
Top