Allow Multiple Conditions for Calculated Properties of Type Count / Sum

I need a custom variable to integrate into a rewards program, it needs apply a value to an “AMOUNT” range for Deals.

Something like this - A new Field “Referral Reward” with the following used to enter the Value:

if (([properties.amount] < 5000, 50) or
([properties.amount] >= 5000 and < 10000, 100) or
([properties.amount] >= 10000 and < 15000, 150) or
([properties.amount] >= 15000 and < 30000, 300) or
([properties.amount] > 30000, 400))

I find it mind-blowing to think that any developer would limit Boolean functionality to a single expression, that’s not how logic equations work!

When will this functionality be available? I’m on a deadline to get this working!