Formula question
 

=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

Formula question
 

pinehead,


methinks too many IFs in the statement.

Try

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


"pinehead" wrote in
message ...

=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

Formula question
 

i'm still getting a #value. Any suggestions on what that may mean?


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

Formula question
 

=IF(B5:E19="Incorrect Figure","Applicant Refused", "Accepte")

This function alone does not work. says #value. Suggestions?


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

Formula question
 

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


--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Beege" wrote in message
...
pinehead,


methinks too many IFs in the statement.

Try

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


"pinehead" wrote
in
message ...

=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

Formula question
 

Thanks, Bob

Pinehead, you may notice that spelling, capitalization, punctuation all
matter here. Below you see "admit" and "Admit". Data entry needs to be
precise, and I'm not the one to know haw to check for all of the different
permutations for input.

Good luck

Beege


"Bob Phillips" <bob.phillips@not

heretiscali.co.uk wrote in message
...
=IF(COUNTIF(B19:F19,"Incorrect Figure")0,"Refused",
IF(COUNTIF(B19:F19,"Perfect Score")0,"Accept",
IF(OR(B5="admit",C5="Admit",D5="Admit",E5="Admit", F5="Admit"),"APPLICANT
ACCEPTED","APPLICANT DENIED")))


--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Beege" wrote in message
...
pinehead,


methinks too many IFs in the statement.

Try

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


"pinehead" wrote
in
message ...

=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