Mod....or Not

[weeze2]

Hi!

I need to use the mod() function in Excel 2003...but I can't and keep getting errors. Is it maybe called something else than 'mod'?

Thanks!

 

[DPlank]

I recommend pressing the F1 key.

Mod is the correct function name, check the help file for details of its use and parameters.

Cheers,
Dave

Probably the only Test Analyst on Tek-Tips...therefore whatever it was that went wrong, I'm to blame...

animadverto vos in Abyssus!

Take a look at Forum1393!

 

[fredericofonseca]

=MOD(10,3) works fine with me (result is 1) (excel 2003)

What error are you getting

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

 

[macropod]

Insufficient data!!

Which version of the mod function (worksheet or vba), what data & modulus and what sort of error?

Cheers

 

[weeze2]

well im trying to use it in the worksheet
and for example tried to test it with =MOD(10,3)

The cell then shows #NAME?

I am using the Danish version though, but that should not be a problem (anyway I have not had problems in the past).

 

[macropod]

Hi weeze2,

Sounds like a typo or syntax problem. For example, =MOD(IO,3).

Alternatively, maybe its called something other than 'MOD' in the Danish version, or you should be using a different separator. Check out #NAME? in the help file and see if that gives you a better idea.

Cheers

 

[byundt]

In Swedish and German, the MOD function is called REST. Danmark being halfway in between, I'm hoping it is called something similar.

 

[weeze2]

Thanks, it works with Rest()!

Strange that one can not use the English syntax in Excel.
I am used to that Access normaly takes the English notation and changes it for you.

Thanks once again everyone.