Excel Formula Needed for 4th place digit

Reply #2

Rakster — Tue, 23 Oct 2007 03:02:47 GMT

Thanks Bud

Reply #1

budward — Tue, 23 Oct 2007 02:56:27 GMT

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

Excel Formula Needed for 4th place digit

Rakster — Tue, 23 Oct 2007 02:37:31 GMT

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))

Sec... [ More ]