case when

select ceiling((zdarea-100)/50),zdarea,
 case
  when zdarea < 100 then 13

--  when ytarea >= 100 and ytarea <150 then 18
--  when ytarea >= 150 and ytarea <200 then 23
--  when ytarea >= 200 and ytarea <250 then 28
  else
   --(case convert(int,(zdarea-100)/50) when 0 then 18 when 1 then 23 when 2 then 28 else 30 end)
    (case ceiling((zdarea-100)/50) when 1 then 18 when 2 then 23 when 3 then 28 else 30 end)
  end
From  room
Where 1=1 and areaname like '%安庆碧桂园%' and zdarea>100

 Select ceiling((zdarea-100)/50),zdarea,
      (case
         when zdarea<100 then 13
   when (ceiling((zdarea-100)/50)*5+13)>30 then 30
   else (ceiling((zdarea-100)/50)*5+13)
    end )
 From  room
 Where 1=1 and areaname like '%安庆碧桂园%'