Welcome Guest
You last visited May 23, 2018, 6:27 am
All times shown are
Eastern Time (GMT-5:00)

# Excel Formula Needed for 4th place digit

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

 Page 1 of 1
Member #19992
August 9, 2005
2894 Posts
Offline
 Posted: October 22, 2007, 10:37 pm - IP Logged

I need some excel users help.

I have the following formulas for the first three digits of a pick 4 but i need to know what I am doing to get the 4th digit to transfer to its proper position.

Say I want to post the number 1234, the 1 would go in 1st postion, the 2 in the 2nd position the 3 in the 3rd and the 4 in the 4th.. I used the following to get the first three positions done but don't know how to get the 4th position placed.

First position   =IF(ISBLANK(B3),"",INT(B3/100))

Second Position  =IF(ISBLANK(B3),"",INT((B3-(O4*100))/10))

Third Postion... =IF(ISBLANK(B3),"",INT((B3-((O4*100)+P4*10))))

Forth Position ???

Can anyone tell me what I do to place that 4th digit?

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

United States
Member #33295
February 19, 2006
699 Posts
Offline
 Posted: October 22, 2007, 10:56 pm - IP Logged

I need some excel users help.

I have the following formulas for the first three digits of a pick 4 but i need to know what I am doing to get the 4th digit to transfer to its proper position.

Say I want to post the number 1234, the 1 would go in 1st postion, the 2 in the 2nd position the 3 in the 3rd and the 4 in the 4th.. I used the following to get the first three positions done but don't know how to get the 4th position placed.

First position   =IF(ISBLANK(B3),"",INT(B3/100))

Second Position  =IF(ISBLANK(B3),"",INT((B3-(O4*100))/10))

Third Postion... =IF(ISBLANK(B3),"",INT((B3-((O4*100)+P4*10))))

Forth Position ???

Can anyone tell me what I do to place that 4th digit?

Hey Rakster,

Here is the formula I use

Pick 4 number in Cell A1

In Cell A2 enter formula   =INT(A1/1000)

In Cell B2 enter formula   =INT((A1-(A2*1000))/100)

In Cell C2 enter formula   =INT((A1-((A2*1000)+(B2*100)))/10)

In Cell D2 enter formula   =INT((A1-((A2*1000)+(B2*100)+(C2*10)/1)))

This formula will breakdown the the Pick 4 number into 4 numbers

Hope this helps you!!.

Bud

Member #19992
August 9, 2005
2894 Posts
Offline
 Posted: October 22, 2007, 11:02 pm - IP Logged

Hey Rakster,

Here is the formula I use

Pick 4 number in Cell A1

In Cell A2 enter formula   =INT(A1/1000)

In Cell B2 enter formula   =INT((A1-(A2*1000))/100)

In Cell C2 enter formula   =INT((A1-((A2*1000)+(B2*100)))/10)

In Cell D2 enter formula   =INT((A1-((A2*1000)+(B2*100)+(C2*10)/1)))

This formula will breakdown the the Pick 4 number into 4 numbers

Hope this helps you!!.

Bud

Thanks Bud!!

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

 Page 1 of 1