You could use the modulus operator to find the remainder, and then use the remainder to round up or down to the closest .25.
To round down, simply take the original value and subtract the remainder.
To round up, if the remainder is 0 keep the original value. Otherwise, take the rounding amount (.25 in this case) and subtract the remainder from it. Add that result to the original value.
SELECT @value AS OriginalValue ,(@value % @RoundingAmount) AS Remainder ,@RoundingAmount AS RoundingAmount ,@RoundingAmount - (@value % @RoundingAmount) AS RoundingAmountMinusRemainder ,@value - (@value % @RoundingAmount) AS RoundDown ,@value + (IIF((@value % @RoundingAmount) = 0, 0, @RoundingAmount - (@value % @RoundingAmount))) AS RoundUp