Welcome Guest
Log In | Register )
You last visited December 7, 2016, 11:24 am
All times shown are
Eastern Time (GMT-5:00)

what's the deal with open office calc?

Topic closed. 4 replies. Last post 5 years ago by starshipwarrior.

Page 1 of 1
PrintE-mailLink
JonnyBgood07's avatar - Patriots logo1.jpg
Connecticut
United States
Member #61623
May 29, 2008
20581 Posts
Offline
Posted: May 6, 2012, 4:59 pm - IP Logged

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.."

 


    Avatar
    Florida
    United States
    Member #66575
    October 30, 2008
    3549 Posts
    Offline
    Posted: May 6, 2012, 5:59 pm - IP Logged

    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


      United States
      Member #124493
      March 14, 2012
      7023 Posts
      Offline
      Posted: May 6, 2012, 6:15 pm - IP Logged

      what is mod??  modus?

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

        JonnyBgood07's avatar - Patriots logo1.jpg
        Connecticut
        United States
        Member #61623
        May 29, 2008
        20581 Posts
        Offline
        Posted: May 6, 2012, 6:20 pm - IP Logged

        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.."

         


          Avatar
          New Member
          Anchorage Alaska
          United States
          Member #127669
          May 6, 2012
          2 Posts
          Offline
          Posted: May 6, 2012, 8:14 pm - IP Logged

          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