I have a data table that I would like to filter based on the data range in another column.
A sample of my dataset is as below:

The current range of prices is as below:

I want to drop all rows that are outside the price range as given below:

I tried a multiple IF, such as :
Filtre = if((Table[Item]= "Apple" and [Price] >= 70 and [Price] <= 120), if(Table[Item]= "Banana" and [Price] >= 45and [Price] <= 55), if (Table[Item]= "Cherry" and [Price] >= 180 and [Price] <= 220), if (Table[Item]= "Grapes" and [Price] >= 135 and [Price] <= 175), 1 ,0)
It doesn't retrieve errors, but it doesn't filter correctly. Any help on the same will be highly appreciated.
Thanks in advance!

