Need a little EXCEL help please

Reply #6

Todd — Fri, 08 Jun 2018 22:11:54 GMT

Reply #5

Raven62 — Fri, 08 Jun 2018 20:48:03 GMT

D2 945

E2 =IF($D2= , ,(MOD($D2,1000)-MOD($D2,100))/100)

F2 =IF($D2= , ,(MOD($D2,100)-MOD($D2,10))/10)

G2 =IF($D2= , ,MOD($D2,10))

D3 532

E3 =IF($D3= , ,(MOD($D3,1000)-MOD($D3,100))/100)

F3 =IF($D3= , ,(MOD($D3,100)-MOD($D3,10))/10)

G3 =IF($D3= , ,MOD($D3,10))

D4 =$E4*100+$F4*10+$G4

E4 =MOD($E2+$E3,10)

F4 =MOD($F2+$F3,10)

G4 =MOD($G2+$G3,10

Reply #4

capett02 — Fri, 08 Jun 2018 20:15:54 GMT

Thank you theo1946

Reply #3

theo1946 — Fri, 08 Jun 2018 19:30:45 GMT

945

632

577

=MOD(A1+A2,1000

Reply #2

capett02 — Fri, 08 Jun 2018 06:36:52 GMT

Thank you. I couldn't remember the MOD for anything. Really appreciate the help.

Reply #1

Oscargrouch05$ — Fri, 08 Jun 2018 06:34:15 GMT

I use excel 2003 example cell A3 first number B3 C3

pick3 number 945 + 532 = 477 how to figure this out on paper and pin

=MOD(SUM(A3-5),10) minus 5 from the first number

=MOD(SUM(B3-7),10) minus 7 from the second number

=MOD(SUM(C3-0+2),10) plus 2 from the third number

Need a little EXCEL help please

capett02 — Fri, 08 Jun 2018 06:08:22 GMT

I have lost all my excel spreadsheets from a damaged flash drive. Now I can't figure out how to get excel to do lottery math for P3. Here is what I want it to do.

945

+ 532

= 477

Not, 945+532= 1477

Can anyone help, please? Thanks in advance.