Welcome Guest
( Log In | Register )
The time is now 9:30 am
You last visited May 24, 2013, 9:30 am
All times shown are
Eastern Time (GMT-5:00)
Update your time zone

what's the deal with open office calc?

Previous TopicNext Topic

Topic closed. 4 replies. Last post 1 year ago by starshipwarrior.

Page 1 of 1
PrintE-mailLink
JonnyBgood07
JonnyBgood07's avatar - god and-adam-and-guitar2.jpg
Connecticut
United States
Member #62108
May 29, 2008
16634 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.

"...Life is not a matter of holding good cards,but sometimes playing a poor hand well...
'Fortune Cookie wisdom'

 


    CarliG
    Avatar
    Florida
    United States
    Member #67077
    October 30, 2008
    3212 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

      LottoBoner
      LottoBoner's avatar - Metatrons 20cube.JPG
      KEEP YOUR EYE ON THE BALL!
      NYC
      United States
      Member #124503
      March 14, 2012
      5037 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
        JonnyBgood07's avatar - god and-adam-and-guitar2.jpg
        Connecticut
        United States
        Member #62108
        May 29, 2008
        16634 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!

        "...Life is not a matter of holding good cards,but sometimes playing a poor hand well...
        'Fortune Cookie wisdom'

         


          starshipwarrior
          Avatar
          New Member
          Anchorage Alaska
          United States
          Member #127679
          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

             
            Page 1 of 1