Excel IF/AND/OR formula support

I have 2 formulas that I need help with - For this first formula, I cannot get the field to give me data for all names and levels it ONLY gives me data for all levels of Bronze but not the others.  ...