Hi All,
This is my first time posting here and I know this should be a quick one. I regularly am able to find the answers to what I need based on other folk's questions, which is greatly helpful!
My problem is in the attached picture, but if it isn't clear, what I am trying to do is populate the "Unit Pass/Fail" column with either "Pass" or "Fail" (Pass if ALL "Pass/Fail" columns = Pass; Fail if ANY "Pass/Fail" columns = Fail), so basically a 100% is required to pass or it's an automatic fail.
This might be a simple IF function, but I've tried so many that I now must seek counsel from the Excel gurus!!!
Thanks in advance for your help!!
Fail-Pass.jpg
Bookmarks