请教老师怎么根据这段SQL语句写出Excel公式？太多If, and, if, or, 实在是很糊涂了。

winds.ch

SQL:
CASE WHEN Thisyear < 0 AND Goal > 0 THEN Thisyear
ELSE CASE WHEN  Thisyear < Goal AND Goal > 0   THEN Thisyear
ELSE CASE  WHEN (Thisyear < Lastyear) OR (Lastyear < 0) THEN Goal
ELSE CASE WHEN (Goal < Lastyear) OR  (Lastyear < Fixed) THEN Goal
ELSE Goal - Lastyear
END
END
END
END AS RedGoal
Goal	Thisyear	Lastyear	Fixed	Excel formula
346	-43	390	250	???