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