using the MOD funktion in excel 2003

[a2apple]

if you look at the column headers you see A, B, C; and i am using
norwegen version of office 2003 i downladed the file you referd to bu
execl will not alow me to install it.

Omar Elroubi

 

[Barb Reinhardt]

Try REST(). I found something that gave a "translation".

 

[Dave Peterson]

Just to add to Barb's response...

Excel's VBA is USA centric. You can use that to your advantage.

Select an empty cell in a worksheet (not A3 or B3, though!)
hit alt-f11 to get to the VBE
hit ctrl-g to see the immediate window
type this and hit enter:

activecell.formula = "=mod(B3-A3,1)"

Then back to excel to see how it was translated.

Try REST(). I found something that gave a "translation".