Welcome Guest
Log In | Register )
You last visited January 20, 2017, 7:01 am
All times shown are
Eastern Time (GMT-5:00)

Excel Formula Needed for 4th place digit

Topic closed. 2 replies. Last post 9 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: 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!

    Avatar

    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

      Rakster's avatar - praying hands.jpg
      Saskatchewan
      Canada
      Member #19992
      August 9, 2005
      2867 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!