Multiple Case Statements

Database

Multiple Case Statements

I need a query to reference the below list and if IN this list, apply the first CAST statement, but if not in the list, apply a different CAST statement looking at unit_sell rather than unit_cost.

Any help would be greatly appreciated.

WHEN state IN('CT','DE','GA','KS','KY','ME','MI','NE','NJ','OH','OH','SD','WA','WV','WI') 

CAST(Unit_cost * (1) AS INTEGER) + (

CASE WHEN unit_cost MOD 1 BETWEEN 0.70 AND 0.90 THEN 0.91

WHEN unit_cost MOD 1 BETWEEN 0.50 AND 0.69 THEN 0.70

WHEN unit_cost MOD 1 BETWEEN 0.30 AND 0.49 THEN 0.50

WHEN unit_cost MOD 1 BETWEEN 0.00 AND 0.29 THEN 0.30

WHEN unit_cost MOD 1 > 0.91 THEN 1.20

ELSE 0.90 END AS cost_rec