IF Statements to check multiple conditions

Hi All,

I have a table (attached) that shows people's progression through a course of 4 parts. I would like use a formula to determine the status of each person's progression. The definitions in my table are -
If you have started a part of the course, you will have a "p" in that part
If you have completed the part you will receive either a "c" or a "co"
If there is a blank in any of the parts you haven't commenced that part.

My logic is -
If you have a "c" or a "co" in all four parts, then your course status is "COMPLETED"
If you have a p in any of the four parts, then your course status is "IN PROGRESS"
If you have a "c" or a "co" in less than the four parts, then your course status is "IN PROGRESS"
If all four parts are blank, then your course status is "NOT COMMENCED"

My search of the forum has confused me as I think I have to use both IF AND statements and IF OR statements and I can't get the order correct.

Any help would be greatly appreciated.

Try this in F2:

=IF(COUNTIF(B2:E2,"")=4,"Not Commenced",IF(OR(COUNTIF(B2:E2,"p")>0,COUNTIF(B2:E2,"c*")<4),"In Progress","Complete"))

Also update your MS-Off Ver shown in your profile. Currently, it says that you are using Excel 2003 but you have uploaded a .xlsx workbook which means that you have ≥ 2007.