dummy variables

[Miloud]

Hello all

i have data on number of employees in culomn A range from 1 to 10000
i need to generat four dummy variables in column B,C,D and E as the following
s=1 if number of employees 1-50 and zero otherwise
m=1 if number of employees 51-100 and zero otherwise
l=1 if number of employees 101-1000 and zero otherwise
xl=1 if number of employees 1001-10000 and zero otherwise

THANKS

[shg]

s: =and(a1>=1, a1<=50) + 0

[Miloud]

Thanks Boss