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

Excel help needed

Topic closed. 2 replies. Last post 10 years ago by Rakster.

Page 1 of 1
PrintE-mailLink
Rakster's avatar - praying hands.jpg
Saskatchewan
Canada
Member #19992
August 9, 2005
2867 Posts
Offline
Posted: May 12, 2007, 8:27 pm - IP Logged

I need some help with a particular issue.

I am trying to break down a sum but want the two numbers of the sum to be in seperate columns.

Example... 654 = sum of 15 I want to have the 1 in a seperate column and the 5 in a seperate column. is there a way of doing this?

Thanks

We are all Lucky... just some of us don't realize it!

    winsumloosesum's avatar - Lottery-060.jpg
    Pennsylvania
    United States
    Member #2218
    September 1, 2003
    5387 Posts
    Offline
    Posted: May 12, 2007, 8:53 pm - IP Logged

    Rakster,

    If you have your sum of 15 in cell A1

    In cell B1 enter the following formula =IF(A1<10,"",LEFT(A1))

    In cell C1 enter the following formula =IF(A1<10,A1,RIGHT(A1))

    There are other formlas you can use.

    The sums range from 0 through 27 so I'm thinking you will have single digit sums.

    The "B" column will have the "tens" and the "C" column will have the "ones".

      Rakster's avatar - praying hands.jpg
      Saskatchewan
      Canada
      Member #19992
      August 9, 2005
      2867 Posts
      Offline
      Posted: May 12, 2007, 9:00 pm - IP Logged

      Rakster,

      If you have your sum of 15 in cell A1

      In cell B1 enter the following formula =IF(A1<10,"",LEFT(A1))

      In cell C1 enter the following formula =IF(A1<10,A1,RIGHT(A1))

      There are other formlas you can use.

      The sums range from 0 through 27 so I'm thinking you will have single digit sums.

      The "B" column will have the "tens" and the "C" column will have the "ones".

      Thank you.!!

      We are all Lucky... just some of us don't realize it!