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.
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.
=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" <[email protected]> wrote in message
news:[email protected]...
> 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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks