Learnt something today.Thanks a great deal!

" wrote:

It took a bit but here ya go:

Enter this formula into X1

=IF(AND(OR(A1="RoHS",A1="RoHS6"),OR(B1="Yes",B1="N o")),"compliant",IF(A1="RoHS5","exempt",IF(A1="No" ,"non
compliant","")))

Enter this formula into Y1

=IF(AND(OR(A1="RoHS",A1="RoHS6"),B1="No"),"does not
meet",IF(AND(A1="RoHs6",B1="Yes"),"check",""))

Enter this formula into Z 2

=IF(AND(A1="RoHs5",X1="exempt"),B7,"")

Ya gotta love boolean operators!!!!!