what's the deal with open office calc?

Just lost my MS office 2010 click2 run yesterday after a restore.Downloaded Open Office and am trying   make my own TTT's for my dailyks but found it's MOD function isn't the same....can anyone help?

I wanted to input my draw number in E1 F1 G1...and have it output in A2 B2 C2

In cell A2 I tried =MOD(E1+3,10) but this just displays (#NAME?) in the cell after I hit enter

I just went through 4 pages looking here and haven't seen an example of how a P3 ttt is with open office.

Jonny

Have you tried using the semicolon instead of the comma  ?

 With Calc, the SEPARATOR between function parameters is a semicolon ( ; ), not a comma as in Excel

=MOD(E1+3;10)

Carlig

what is mod??  modus?

what the hell is modus...it looks so gross, i dont even want to look it up...

you're the man carl!!!  Thanks!

Can I see or get a copy of the spread sheet or just the formulas you used I use cal all the time and someties it drives you crazy LOL