excel in a formula please click tips

I would like to achieve in the form of the following data:When the column B is less than 100, C out = A column, when the B listed in the 100-200 when, D out out = A, B out when more than 200 hours, E out = A

Out I forgot the formula, under the prompt

= IF (B1> 200, E1 = A1 , IF (B1> = 100, D1 = A1, C1 = A1)) in the C1 enter the formula = IF ($ B1 <100, A1 ,””), down and then copy the formula
in D1 enter = IF (AND ($ B1> = 100, $ B1 <= 200), A1 ,””), then copy
down in the E1 input formula = IF ($ B1> 200, A1 ,””), then copy down the Is not right.
At the same time, three cell operation, the array can only be used, how specific do? Do not know in cell C1 enter the formula:= IF (B1 <100, A1 ,””)
in D1 cells enter the formula:= IF (AND (B1 100), A1 ,””)
in the E1 cells enter the formula:= IF (B1> 200, A1, “”)
and then C1, D1, E1 cell of the three selected, you can copy down.