Select range of numbers from fields and display data in text fields

Hi,

I have a datatype called FLOOR and it has min kilo wat and max kilo wat, and prices for economy, standard and premium. user will enter a number of kw as text input and i want to show the price in three different text boxes. I tried doing conditional approach , but i don’t get AND option and i really got stuck here. please let me know the solution to achieve this

data

output :slight_smile: