Any function regarding remainder??? [Solved]

[wasim_sono]

Hi All

I want to know that if there are any function is available which define the remainder of division.


I mean that I divide 15 by 10 then the answer is 1 and remainder is 5. so how can we get this 5, by using any function or something else?

Thanks.

Wasim

[iandarkwater]

Hi Wasim

Try

15 Mod 10

This divides the first number by the second & returns the remainder.

[YourNumber]-Int([YourNumber])

to return the part of YourNumber to the right of the dp

Ian

[wasim_sono]

Dear Ian

Thanks for ur reply. but it's not working. I store the values in a variable "Sum". Now I write as

Sum mod 10

but there is complie error message appears.
Please explain how to use this function in VBA.

Thanks.

Wasim