Welcome Guest
You last visited January 24, 2017, 6:17 pm
All times shown are
Eastern Time (GMT-5:00)

# Open Office Excel Question

Topic closed. 5 replies. Last post 5 years ago by eazy4now.

 Page 1 of 1
Tn
United States
Member #54963
September 4, 2007
1166 Posts
Offline
 Posted: January 12, 2012, 9:33 am - IP Logged

Ok guys and gals anyone who can help! lol Lets say I have a number say 3 in cell I1 and then another number say 8 in cell H2 and say I add them or sum them into cell I2 and it equals 13 but I dont want 13 I just want the 3 how do I make it do this? Any help is appreciated!

WHEN IT FEELS THE WHOLE WORLD SUCKS!

RELAX.........IT'S ONLY GRAVITY

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

Pennsylvania
United States
Member #2218
September 1, 2003
5397 Posts
Online
 Posted: January 12, 2012, 8:55 pm - IP Logged

Ok guys and gals anyone who can help! lol Lets say I have a number say 3 in cell I1 and then another number say 8 in cell H2 and say I add them or sum them into cell I2 and it equals 13 but I dont want 13 I just want the 3 how do I make it do this? Any help is appreciated!

3 + 8 = 11 (I think lol)

Try this:

=IF(SUM(H2;I1)>9 ;RIGHT(SUM(H2;I1)))

Tn
United States
Member #54963
September 4, 2007
1166 Posts
Offline
 Posted: January 13, 2012, 1:10 pm - IP Logged

3 + 8 = 11 (I think lol)

Try this:

=IF(SUM(H2;I1)>9 ;RIGHT(SUM(H2;I1)))

Yes winsum it does equal 11 lmao tooooo many numbers in my head but i got it solved now anyways thanks!!

WHEN IT FEELS THE WHOLE WORLD SUCKS!

RELAX.........IT'S ONLY GRAVITY

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

New Jersey
United States
Member #17843
June 28, 2005
51284 Posts
Offline
 Posted: January 24, 2012, 5:18 pm - IP Logged

Ok guys and gals anyone who can help! lol Lets say I have a number say 3 in cell I1 and then another number say 8 in cell H2 and say I add them or sum them into cell I2 and it equals 13 but I dont want 13 I just want the 3 how do I make it do this? Any help is appreciated!

=MOD(H2+I2,10)

A mind once stretched by a new idea never returns to its original dimensions!

Stone Mountain*Georgia
United States
Member #828
November 2, 2002
10491 Posts
Offline
 Posted: January 24, 2012, 6:05 pm - IP Logged

Wow Raven.... good to see you post again. You have been missed. October ? Don't leave us hanging like that ..... always enjoy your post sir. Even if you are from New Jersey. Well, I guess I like your Governor too .... LOL

The only real failure .....is the failure to try.

Luck is a very rare thing....... Odds not so much.

Odds never change .....but probability does.

Win d

New Jersey
United States
Member #2365
September 22, 2003
4777 Posts
Offline
 Posted: February 19, 2012, 6:58 am - IP Logged

=MOD(H2+I2,10)

Raven,

Could you please post for New Jersey with Calabs

Thanks

Eazy

I missed you too.

 Page 1 of 1