{1;2;3;4;5;6;7;8;9;10} to {1;2;0;0;0;6;7;0;0;10}

Cell A1:A10 has number 1:10
B1 = 3
C1 = 5
B2 = 8
C2 = 9

I use this array formula

{=IF(((A1:A10<B1)+(A1:A10>C1))*((A1:A10<B2)+(A1:A10>C2)),A1:A10,0)}

to get {1;2;0;0;0;6;7;0;0;10}

which makes number 3 to 5 and number 8 to 9 to be 0 instead.

Is there any shorter array formula?

My real situation has number from 150 to 25000 that need to replace number from 200-250, 400-570, 15000-16000, 21200-23400 to be 0. Interval of 0 may be change and/or increase/decrease in future.

I understand deeply enough for array and vba. Please advise array formula.

Thanks,
Somkiat