[resolved]EXCEL question

X=a or b, and if x=1, acceptable
z=c or d or e and if x >= 0.8, acceptable
all other combination are rejected
how can it be formulate?
thanks

[ 本帖最後由 colabear 於 2008-11-18 11:28 編輯 ]