Earl Kiosterud wrote:

=IF(AND(A3=1,A3<=9),CHOOSE(A3,11,8,7,0,0,0,0,0,0) ,0)

This works fine by pasting into B1,B2,B3 and amending the function.

Thanks.

--