Formula question

P

pinehead

=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?
 
B

Beege

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"))
 
P

pinehead

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

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

Bob Phillips

=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)
 
B

Beege

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
 
Top