Sorry for being thick here but if there are no negative numbers doesn't that mean that you will always use formula B and the criteria Y>0 is redundant?

Also, if the results from from both formulas are to go in D2:D11 I can't see how it'll work.