Modifying an If Statement
 

I am using this:

=IF($C1=0;$D1;IF($C1<=0.15;$C1;IF(AND($B1<0;$C1< 0);ROUNDDOWN(MEDIAN($B1:$C1);1);$D1)))

Would like to add another condition. If B1<=.10 and C1=5, then return .15.

Thank you in advance.

Modifying an If Statement
 

=IF($C1=0;$D1;IF($C1<=0.15;$C1;IF(AND(B1<=.10;C1=5 );.15;IF($B1<0;ROUNDDOWN(
MEDIAN($B1:$C1);1);$D1))))


--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"carl" wrote in message
...
I am using this:


=IF($C1=0;$D1;IF($C1<=0.15;$C1;IF(AND($B1<0;$C1< 0);ROUNDDOWN(MEDIAN($B1:$C
1);1);$D1)))

Would like to add another condition. If B1<=.10 and C1=5, then return .15.

Thank you in advance.