Nested If Statement

I've been working on this formula for a while. It seems so simple in thought but I'm only getting "Not Required Training" when I use it. It is not using the nested If part.

The idea is if the range of cells is blank, then I want it to say "Not Required Training". If in the range of cells there is a Not Complete then I want it to say "Not Complete". If in the range of cells has only complete, then I want it to say "Complete".

Please Login or Register  to view this content.

Any suggestions?

As it stands you'll get "Not Required Training" if any cells in the range are blank, if you only want that when they are all blank try

=IF(COUNTBLANK(BF2:CD2)=COLUMNS(BF2:CD2),"Not Required Training",IF(COUNTIF(BF2:CD2,"Not Complete"),"Not Complete","Complete"))