software

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.

=IF(D1lt;gt;quot;quot;;D1;IF(OR(C1-B1gt;4,C1-B1lt;10);0;ROUNDDOWN(MEDIAN($B1:$C1);1)))

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

quot;carlquot; gt; wrote in message
...
gt; Trying to put this into Excel.
gt;
gt; If D is not empty, use D. If C-B is greater than 4 or negative, and C or B
gt; is less than 10, then 0. Other wise ROUNDDOWN(MEDIAN($B1:$C1);1).
gt;
gt; Thank you in advance.

=IF(D1lt;gt;quot;quot;,D1,IF(AND(OR(C1-B1lt;0,C1-B1gt;4),OR(C1lt;10,B1lt;10)),0,ROUNDDOWN(MEDIAN(B1:C1),1 )))

Does that help?

Steve--
SteveG
------------------------------------------------------------------------
SteveG's Profile: www.excelforum.com/member.php...foamp;userid=7571
View this thread: www.excelforum.com/showthread...hreadid=510229