My intention is to create a formula that states if cell value (AZ2) is 0 then return "Not Applicable", If the Cell value is between 1 and 96 then return "Training" and if the cell value exceeds 96 then return "Trained".
This is the formula I have been working on but wont be accepted. Where am I going wrong?
=IF((AZ2>=96, "Trained"), IF(AND(AZ2>96, AZ2<0), "Training", "Not Applicable"))
Bookmarks