Welcome Guest
( Log In | Register )
The time is now 9:16 am
All times shown are
Eastern Time (GMT-5:00)
Update your time zone

Open Office Excel QuestionPrevious TopicNext Topic

Topic closed. 5 replies. Last post 3 months ago by eazy4now.

Page 1 of 1
PrintE-mailLink
bootleg233
bootleg233's avatar - Lottery-034.jpg
Tn
United States
Member #55432
September 4, 2007
507 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
    Avatar

    United States
    Member #2256
    September 1, 2003
    3309 Posts
    Offline
    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
      bootleg233's avatar - Lottery-034.jpg
      Tn
      United States
      Member #55432
      September 4, 2007
      507 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
        Raven62's avatar - binary
        New Jersey
        United States
        Member #18150
        June 28, 2005
        17927 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
          WIN D's avatar - e255740
          Stone Mountain*Georgia
          United States
          Member #837
          November 2, 2002
          9089 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   

          Amazing Photos: The Little Things in Life       "It's just as important to show how you missed the number ......as how you hit it." 

            eazy4now
            eazy4now's avatar - Lottery-062.jpg
            Eazy
            NewJersey
            United States
            Member #2407
            September 22, 2003
            340 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