Trying to put this into Excel.

If D is not empty, use D. If C-B is greater than 4 or negative, and C or B
is less than 10, then 0. Other wise ROUNDDOWN(MEDIAN($B1:$C1);1).

Thank you in advance.