Mod Function

[281975]

Friends,

how can i do this in excel 2002?
mod(1234567890123,97)

thanks

[raypayette]

You have to recompose the formula:

a = 1234567890123# / 97# - (Int(1234567890123# / 97#))
MsgBox a * 97

[Norie]

In a formula:

=(1234567890123/97 - INT(1234567890123/97))*97

Though you won't get an exact result due to floating point issues.

[daddylonglegs]

Instead of

=MOD(A1,B1)

try

=A1-FLOOR(A1,B1)

assumes A1 & B1 are positive numbers

[281975]

thanks daddylonglegs

its working fine for 13 digits....but i need it for maximum 24 digits

for example.....

mod(95000000922019182020281000,97)=24

but in excel im getting the value as 0
also when i type the 24 digits its show like ..... #NUM!