How do I return specific results based on information in other cells.

[bradfordahill]

Hello -

I am creating an attendance tracker for work but currently I am having brain freeze and can figure out how to create a formula that tells me the following.

In Column D - I want it state, "Review of Expectations", "PIP Required" or just be "blank" based on information in Column AU as well as Columns E,F and G.

If Employee 1 has 2.5 in column AU15 then "Review of Expectations" should appear in Column D15. Once the Supervisor selects "YES" in Cell E15 then Cell D15 should return to blank.

If Employee 1 has 3 in Column AU15 then "Verbal Required" should display in D15 until the supervisor inputs "YES" in Cell E15 then Cell D15 will return to Blank.

If Employee 1 has 4 in column AU15 then, "Written Required" should display in D15 until the supervisor inputs "YES" in Cell F15 then Cell D15 will return to blank.

Finally, If employee 1 has 6 in column AU15 then, "Final Required" should display in D15 until the supervisor inputs "Yes" in cell G15 then cell D15 will return to blank.

Please review the attached and give me some assistance.

If asked for a Password, please input "MoonPie".

Thanks,