[Webinar] Learn how to a build a cloud-first strategyRegister Now

x
Solved

# Detect remainder

Posted on 2004-11-17
Medium Priority
431 Views
Hi

If I divided a number, how would I find out if there was a remainder after the division

Thanks
0
• 2

LVL 2

Accepted Solution

koruzica earned 2000 total points
ID: 12610538
you could use

reminder=num1 MOD num2

which gives you the reminder...

0

LVL 2

Expert Comment

ID: 12610543
I mean remainder :)
0

LVL 4

Author Comment

ID: 12610576
Just found this sample which detects a leap year

Function bIsLeapYear(ByVal dDate As Double) As Boolean
bIsLeapYear = ((dDate Mod 4 = 0) And (dDate Mod 100 <> 0)) Or (dDate Mod 400 = 0)
End Function

0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It’s quite interesting for me as I worked with Excel using vb.net for some time. Here are some topics which I know want to share with others whom this might help. First of all if you are working with Excel then you need to Download the Following …
Parsing a CSV file is a task that we are confronted with regularly, and although there are a vast number of means to do this, as a newbie, the field can be confusing and the tools can seem complex. A simple solution to parsing a customized CSV fi…
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…
As many of you are aware about Scanpst.exe utility which is owned by Microsoft itself to repair inaccessible or damaged PST files, but the question is do you really think Scanpst.exe is capable to repair all sorts of PST related corruption issues?
###### Suggested Courses
Course of the Month20 days, 12 hours left to enroll

#### 864 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.