Decide whether the faculty is to be promoted in the range


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")

Request for Solution File

Ask an Expert for Answer!!
Operation Management: Decide whether the faculty is to be promoted in the range
Reference No:- TGS02549349

Expected delivery within 24 Hours