what's the deal with open office calc?

Reply #4

starshipwarrior — Mon, 07 May 2012 00:14:52 GMT

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

Reply #3

JonnyBgood07 — Sun, 06 May 2012 22:20:00 GMT

you're the man carl!!! Thanks

Reply #2

LottoBoner — Sun, 06 May 2012 22:15:41 GMT

what is mod?? modus?

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

Reply #1

CarliG — Sun, 06 May 2012 21:59:38 GMT

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's the deal with open office calc?

JonnyBgood07 — Sun, 06 May 2012 20:59:40 GMT

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.... [ More ]