**Excel Formulas for Last Digits**

Hi GillesD,

Not to worry, I think I have managed to construct the Excel Formulas for Last Digits. For some reason I seemed to have a mental block, a bit like not seeing the wood for trees.

Anyway, I think they are O.K. and I have posted them below :-

Distribution 1-1-1-1-1-1

=COMBIN(9,6)*COMBIN(5,1)*COMBIN(5,1)*COMBIN(5,1)*COMBIN(5,1)*COMBIN(5,1)*COMBIN(5,1)+COMBIN(4,1)*COMBIN(9,5)*COMBIN(5,1)*COMBIN(5,1)*COMBIN(5,1)*COMBIN(5,1)*COMBIN(5,1)

Distribution 2-1-1-1-1-0

=COMBIN(9,1)*COMBIN(5,2)*COMBIN(8,4)*COMBIN(5,1)*COMBIN(5,1)*COMBIN(5,1)*COMBIN(5,1)+COMBIN(4,1)*COMBIN(9,1)*COMBIN(5,2)*COMBIN(8,3)*COMBIN(5,1)*COMBIN(5,1)*COMBIN(5,1)+COMBIN(4,2)*COMBIN(9,4)*COMBIN(5,1)*COMBIN(5,1)*COMBIN(5,1)*COMBIN(5,1)

Distribution 2-2-1-1-0-0

=COMBIN(9,2)*COMBIN(5,2)*COMBIN(5,2)*COMBIN(7,2)*COMBIN(5,1)*COMBIN(5,1)+COMBIN(4,1)*COMBIN(9,2)*COMBIN(5,2)*COMBIN(5,2)*COMBIN(7,1)*COMBIN(5,1)+COMBIN(4,2)*COMBIN(9,1)*COMBIN(5,2)*COMBIN(8,2)*COMBIN(5,1)*COMBIN(5,1)

Distribution 2-2-2-0-0-0

=COMBIN(9,3)*COMBIN(5,2)*COMBIN(5,2)*COMBIN(5,2)+COMBIN(4,2)*COMBIN(9,2)*COMBIN(5,2)*COMBIN(5,2)

Distribution 3-1-1-1-0-0

=COMBIN(9,1)*COMBIN(5,3)*COMBIN(8,3)*COMBIN(5,1)*COMBIN(5,1)*COMBIN(5,1)+COMBIN(4,1)*COMBIN(9,1)*COMBIN(5,3)*COMBIN(8,2)*COMBIN(5,1)*COMBIN(5,1)+COMBIN(4,3)*COMBIN(9,3)*COMBIN(5,1)*COMBIN(5,1)*COMBIN(5,1)

Distribution 3-2-1-0-0-0

=COMBIN(9,1)*COMBIN(5,3)*COMBIN(8,1)*COMBIN(5,2)*COMBIN(7,1)*COMBIN(5,1)+COMBIN(4,1)*COMBIN(9,1)*COMBIN(5,3)*COMBIN(8,1)*COMBIN(5,2)+COMBIN(4,2)*COMBIN(9,1)*COMBIN(5,3)*COMBIN(8,1)*COMBIN(5,1)+COMBIN(4,3)*COMBIN(9,1)*COMBIN(5,2)*COMBIN(8,1)*COMBIN(5,1)

Distribution 3-3-0-0-0-0

=COMBIN(9,2)*COMBIN(5,3)*COMBIN(5,3)+COMBIN(4,3)*COMBIN(9,1)*COMBIN(5,3)

Distribution 4-1-1-0-0-0

=COMBIN(9,1)*COMBIN(5,4)*COMBIN(8,2)*COMBIN(5,1)*COMBIN(5,1)+COMBIN(4,1)*COMBIN(9,1)*COMBIN(5,4)*COMBIN(8,1)*COMBIN(5,1)+COMBIN(4,4)*COMBIN(9,2)*COMBIN(5,1)*COMBIN(5,1)

Distribution 4-2-0-0-0-0

=COMBIN(9,1)*COMBIN(5,4)*COMBIN(8,1)*COMBIN(5,2)+COMBIN(4,2)*COMBIN(9,1)*COMBIN(5,4)+COMBIN(4,4)*COMBIN(9,1)*COMBIN(5,2)

Distribution 5-1-0-0-0-0

=COMBIN(9,1)*COMBIN(5,5)*COMBIN(8,1)*COMBIN(5,1)+COMBIN(4,1)*COMBIN(9,1)*COMBIN(5,5)

Regards

PAB