Paul:

How about this formula:

=IF(AND(J$24=$E27,J$24<=$F27),IF(OR(D1="Apples", D1=
"Oranges"),E2,"Failed"),"Try Again")


--
Marguerite


"Paul" wrote:

Hi all,

Newbie question: I would like to add other attributes to a formula that
i have and I'm not sure how to formulate but it would sound something like
this:

=IF(AND(J$24=$E27;J$24<=$F27);1;"") and IF D1= "Apple" or "Oranges" return
value from D2 (ex:it woud be 75%)


I do want to keep the AND(J$24=$E27;J$24<=$F27) as it's coupled with
conditional formatting in my sheet.

Thanks for your help!

Paul
Please help