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".
=IF(COUNTBLANK(BF2:CD2),"Not Required Training",IF(COUNTIF(BF2:CD2,"Not Complete"),"Not Complete","Complete"))
Any suggestions?
Bookmarks