Welcome Guest
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
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

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

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.

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

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

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

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

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

 Page 1 of 1