Decide whether the faculty is to be promoted in the range of K3 to K23: Construct a formula such that if the salary growth is positive (salary in the year 2016 is strictly greater than the salary in year 2015) and the rank is "Assistant" or "Associate", output "yes". Otherwise output "No".
This is what i have but its not working, =IF(AND(I3>H3, E3="Assistant", E3="Associate"), "Yes","No")