Here is my function below. I am getting the "#NAME?" in the sell containing the formula. Any ideas as to what is wrong here?
=IF(AND(B5="standard",B6="standard",B7="standard"),"standard",IF(AND(B5="Level 1",B6="Level 1",B7="Level 1"),"Level 1",IF(AND(B5="Level 2",B6="Level 2",B7="Level 2"),"Level 2",IF(AND(B5="Level 3",B6="Level 3",B7="Level 3"), "Level 3", IF(AND(B5="Level 4",B6="Level 4",B7="Level 4"),"Level 4", Custom)))))
Cell B5 contains "standard"
Cell B6 contains "Level 1"
Cell B7 contains "standard"
Cell B8 contains "standard"
Bookmarks