Receipe to use for distributing rows in different ranges based on values of Single column

I would like to use a recipe that can distribute rows in different ranges based on values of a single column.

I would like to do following. Y is the column. I would like to distribute the rows in following manner

• 15=<Y<31 = One range
• 31<=Y <= 35 = Second range
• 40<=Y <= 45 = Third Range
• Y>=50 = Fourth range

I want to do that so that i can run the below formula afterwards.

Var X (Remaining quantity)
IF (15=<Y<31) { X = A - B}
ELSE IF
(31<=Y <= 35 ) {
X = C - B}
ELSE IF
(40<=Y <= 45) {
X = D - B}
ELSE IF
(Y>=50) {
X==0
}