Thread
:
Modifying an If Statement
View Single Post
#
1
Posted to microsoft.public.excel.worksheet.functions
carl
Posts: n/a
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.
Reply With Quote