Excel Help Request

Reply #3

Raven62 — Sat, 07 Mar 2020 17:21:39 GMT

Cell K3: =IF(ISBLANK(J3), ,INT(J3/1000))

Cell L3: =IF(ISBLANK(J3), ,INT((J3-(K3*1000))/100))

Cell M3: =IF(ISBLANK(J3), ,INT((J3-((K3*1000)+(L3*100)))/10))

Cell N3: =IF(ISBLANK(J3), ,INT((J3-((K3*1000)+(L3*100)+(M3*10

Reply #2

Bob — Sat, 07 Mar 2020 13:46:06 GMT

This is what we have----

4digit conversion formula

1234---in one cell

1234---in single cells

digit1-----------=LEFT(B2)

digit2-----------=MID(B2,2,1)

digit3-----------=MID(B2,3,1)

digit4-----------=MID(B2,4,1)

--------------------------------------

to put them back in one cell

digits ---- = CONCATENATE(AD5,AE5,AF5,AG5)

this formula will put all 4 digit

in one cell...

---------------------------------------

3digit single cells

123

digit 1

Reply #1

Rakster — Thu, 05 Mar 2020 03:30:32 GMT

Never mind... I figured it out.

Excel Help Request

Rakster — Thu, 05 Mar 2020 00:56:14 GMT

I am trying to put a pick 4 system together and I am not sure how to formulate the last digit.

Here are the formula's I used for the first 3 digits from left to right.... Ex # 1234

=IF(ISBLANK(J3), ,INT(J3/100)) this formula is for the first left hand digit... 1

=IF(ISBLANK(J3), ,INT((J3-(K3*100))/10)) this is for the second digit from the left 2

=IF(ISBLANK(J3), ,INT((J3-((K3*100)+L3*10)))) this is for the 3rd digit from the left 3

I need the formula for the last digit....the... [ More ]