Filtering or displaying multiple conditions

[dfwcomputer]

Hi all,

First time poster so hello everyone....


I have a spreadsheet with multiple data and I would like to filter it for specific data display.

Ive attached the file to make it easier.
Basically I have it working but only if I filter by 150 .My issue is how do i then filter e.g. 150 - 300 and 300 - 450 as options.

Code I'm currently using is below but this only allows for the number in the drop box that is selected.Hopefully this makes sense.

=OR(IF(ISBLANK(G7), G7<>"",G7<=$G$1),IF(ISBLANK(H7), H7<>"",H7<=$G$2),IF(ISBLANK(I7), I7<>"", I7<=$G$3))

Possibly a better way of doing it but I'm not that advanced at excel so any help would be greatly appreciated.
Dean