=IF(B19:F19 = "Incorrect Figure", "Refused", IF(B19:F19 = "Perfect
Score", "Applicant Accepted", IF(B5="admit", IF(C5="Admit",
IF(D5="Admit", IF(E5="Admit", IF(F5="Admit", "APPLICANT ACCEPTED",
"APPLICANT DENIED")))))))

Thats my wonderful forumal. It odens't work.

Basically what i think it says is "If any cells through b19:f19 =
"incorrect figure" than refused, else check to see if any of the cells
in b19:f19 =perfect score then accept, and if not then check each
individual criteria.

But it doenst work.
Suggestions?


--
pinehead
------------------------------------------------------------------------
pinehead's Profile: http://www.excelforum.com/member.php...o&userid=31721
View this thread: http://www.excelforum.com/showthread...hreadid=516688