what's the deal with open office calc?Prev TopicNext Topic

• JonnyBgood07

  

  100

  Connecticut
  United States
  Member #61,621
  May 29, 2008
  20,581 Posts
  Offline
  May 6, 2012, 4:59 pm

  ▲▼

  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.

  "No matter how bad things may get, I'd like to thank my middle finger

  for always sticking up for me.."

   

  
  
• CarliG

  

  Florida
  United States
  Member #66,573
  October 30, 2008
  3,547 Posts
  Offline
  May 6, 2012, 5:59 pm

  ▲▼
  In response to JonnyBgood07

  Quote: Originally posted by JonnyBgood07 on May 6, 2012

  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
• LottoBoner

  United States
  Member #124,487
  March 14, 2012
  7,021 Posts
  Offline
  May 6, 2012, 6:15 pm

  ▲▼

  what is mod??  modus?

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

  

  100

  Connecticut
  United States
  Member #61,621
  May 29, 2008
  20,581 Posts
  Offline
  May 6, 2012, 6:20 pm

  ▲▼
  In response to CarliG

  Quote: Originally posted by CarliG on May 6, 2012

  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

  you're the man carl!!!  Thanks!

  "No matter how bad things may get, I'd like to thank my middle finger

  for always sticking up for me.."

   

  
  
• starshipwarrior

  

  Anchorage Alaska
  United States
  Member #127,663
  May 6, 2012
  2 Posts
  Offline
  May 6, 2012, 8:14 pm

  ▲▼

  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