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

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".

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!

 Page 1 of 1