E
eleanor
I have 2 formulas in 2 different cells. How do I combine them and pu
into 1 cell. Appreciate your help. Thanks
formula 1 : =IF(AND(P37>=0.1,Q37>=0.15,R37<=0),"BLUE","")
formula 2
=IF(AND(AND(P37>=0.05,P37<0.1),AND(Q37>=0.1,Q37<0.15),AND(R37>0,R37<0.2)),"BLACK","")
Regard
Attachment filename: test.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=45137
into 1 cell. Appreciate your help. Thanks
formula 1 : =IF(AND(P37>=0.1,Q37>=0.15,R37<=0),"BLUE","")
formula 2
=IF(AND(AND(P37>=0.05,P37<0.1),AND(Q37>=0.1,Q37<0.15),AND(R37>0,R37<0.2)),"BLACK","")
Regard
Attachment filename: test.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=45137