Welcome Guest
Log In | Register )
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
51
PrintE-mailLink
bootleg233's avatar - Lottery-034.jpg
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 Big Smile

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

    winsumloosesum's avatar - Lottery-060.jpg
    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)))

      bootleg233's avatar - Lottery-034.jpg
      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 Big Smile

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

        Raven62's avatar - binary
        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!

          WIN  D's avatar - q05Q0
          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    

            eazy4now's avatar - jteEJ6
            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.