what's the deal with open office calc? http://www.lotterypost.com/thread/245857 Lottery Post Forum Topic: what's the deal with open office calc? en-us Lottery Post RSS Generator Reply #4 http://www.lotterypost.com/thread/245857/2520725 http://www.lotterypost.com/thread/245857/2520725 Mon, 07 May 2012 00:14:52 GMT starshipwarrior starshipwarrior Reply #3 http://www.lotterypost.com/thread/245857/2520574 http://www.lotterypost.com/thread/245857/2520574 Sun, 06 May 2012 22:20:00 GMT JonnyBgood07 JonnyBgood07 Reply #2 http://www.lotterypost.com/thread/245857/2520568 http://www.lotterypost.com/thread/245857/2520568 Sun, 06 May 2012 22:15:41 GMT LottoBoner
what the hell is modus...it looks so gross, i dont even want to look it up...]]> LottoBoner Reply #1 http://www.lotterypost.com/thread/245857/2520546 http://www.lotterypost.com/thread/245857/2520546 Sun, 06 May 2012 21:59:38 GMT CarliG
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]]> CarliG what's the deal with open office calc? http://www.lotterypost.com/thread/245857 http://www.lotterypost.com/thread/245857 Sun, 06 May 2012 20:59:40 GMT JonnyBgood07
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.]]> JonnyBgood07