you can do this today. Although there is no Between function you can write it out mathematically. Example

IF Amount >= 1 and Amount <=20 then 'Small'

ELSEIF Amount >=21 and Amount <=40 then 'Medium'

Else 'Large'

END