I have a value in column "A:A" like this,

"A1" - 517
"A2" - 220
"A3" - 252
"A4" - 172


I want get them to work together in the same statement.
Following condition

in "C1"

1) If "A1" less than 200 or greater than 100 give a value of "B1"
2) If "A1" less than 300,or greater than 200 give a value of "B1"
3) If "A1" less than 400 or greater than 300 give a value of "B1"
4) If "A1" less than 500 or greater than 400 give a value of "B1"
5) If "A1" less than 600 or greater than 500 give a value of "B1"
else 0.

Any help would be greatly appreciated!
Sincerely,

Hitesh