combine the 2 formulas

[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

 

[Bernie Deitrick]

Eleanor,

=IF(AND(P37>=0.1,Q37>=0.15,R37<=0),"BLUE",IF(AND(P37>=0.05,P37<0.1,Q37>=0.1,
Q37<0.15,R37>0,R37<0.2),"BLACK",""))

All on one line - it will probably wrap due to the news reader programs....

HTH,
Bernie
MS Excel MVP