CASE WHEN curOther > .04 THEN curOther * 1 -- Keep the number as it is WHEN curOther >= .01 AND curOther <= .04 THEN curOther * .25 -- Multiply by 0.25 if between 0.01 and 0.04 ELSE curOther -- If it’s below .01, do nothing END