MOD function problem

**tqm1** · 06-07-2007, 01:12 AM

Dear Experts

Please Login or Register  to view this content.

The actual value of variable C is 22 but here it displays 2.
Range("a14") must display 965-22

What is wrong?

Please help

**Paul** · 06-07-2007, 02:56 AM

There is actually a bug in the VBA MOD function, in that it converts both values (the number and divisor) into integers prior to determining the MOD result. ( See http://www.bygsoftware.com/issues/modbug.html )

Instead of your 'c = a Mod 37.324' line, use this instead:

Please Login or Register  to view this content.

**antoka05** · 06-07-2007, 02:57 AM

Mod works only with integer values, it rounds 37.324 to 37 and give you the same result than '36040 mod 37'.

You can change your code:

Please Login or Register  to view this content.

with:

Please Login or Register  to view this content.

Regards,
Antonio

MOD function problem

LinkBack

Thread Tools

Display

MOD function problem

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions