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

All smart people lol

Topic closed. 4 replies. Last post 4 years ago by bootleg233.

Page 1 of 1
PrintE-mailLink
bootleg233's avatar - Lottery-034.jpg
Tn
United States
Member #54963
September 4, 2007
1164 Posts
Offline
Posted: May 23, 2013, 12:50 pm - IP Logged

How can I add a number in open office without going over a limit? Let me explain.. say I want to add 3 to 35 but 35 is my top number so I want it to be 35+3=3. It just starts back at 1. Hope it makes sense lol

WHEN IT FEELS THE WHOLE WORLD SUCKS!

RELAX.........IT'S ONLY GRAVITY Big Smile

I think I can I think I can!!!!

    Avatar

    United States
    Member #41846
    June 23, 2006
    459 Posts
    Offline
    Posted: May 23, 2013, 2:10 pm - IP Logged

    in excel  I would use  =mod(a1+b1,35)   this assumes your two values are in cells a1 and b1 and that your max value is 35.   I understand most things work the same in open office, but I can't confirm that.

      bootleg233's avatar - Lottery-034.jpg
      Tn
      United States
      Member #54963
      September 4, 2007
      1164 Posts
      Offline
      Posted: May 23, 2013, 3:29 pm - IP Logged

      in excel  I would use  =mod(a1+b1,35)   this assumes your two values are in cells a1 and b1 and that your max value is 35.   I understand most things work the same in open office, but I can't confirm that.

      Ok I want to take A1-E1 +3 to each one and place in G1-K1 but none can be over 35 such as E1. So I was just trying to find how to make it start again at 1 but its over my head! LOL Ty phileight for trying to help.

      WHEN IT FEELS THE WHOLE WORLD SUCKS!

      RELAX.........IT'S ONLY GRAVITY Big Smile

      I think I can I think I can!!!!

        Avatar

        United States
        Member #41846
        June 23, 2006
        459 Posts
        Offline
        Posted: May 23, 2013, 8:07 pm - IP Logged

        Ok I want to take A1-E1 +3 to each one and place in G1-K1 but none can be over 35 such as E1. So I was just trying to find how to make it start again at 1 but its over my head! LOL Ty phileight for trying to help.

        I must have misunderstood what you wanted.  if you want the result to be 1 then try this formula in cell K1    =if(e1+3>35,1,(e1+3))

        you can read this as     if e1 +3 greater than 35 then display the value 1 otherwise display the sum of e1 + 3

        you would probably also want the formula in cell k1 adjust the references appropiately

          bootleg233's avatar - Lottery-034.jpg
          Tn
          United States
          Member #54963
          September 4, 2007
          1164 Posts
          Offline
          Posted: May 23, 2013, 10:41 pm - IP Logged

          I must have misunderstood what you wanted.  if you want the result to be 1 then try this formula in cell K1    =if(e1+3>35,1,(e1+3))

          you can read this as     if e1 +3 greater than 35 then display the value 1 otherwise display the sum of e1 + 3

          you would probably also want the formula in cell k1 adjust the references appropiately

          Ty phileight I will try soon as I can Ty again!

          WHEN IT FEELS THE WHOLE WORLD SUCKS!

          RELAX.........IT'S ONLY GRAVITY Big Smile

          I think I can I think I can!!!!