software

=IF(B19:F19 = quot;Incorrect Figurequot;, quot;Refusedquot;, IF(B19:F19 = quot;Perfect
Scorequot;, quot;Applicant Acceptedquot;, IF(B5=quot;admitquot;, IF(C5=quot;Admitquot;,
IF(D5=quot;Admitquot;, IF(E5=quot;Admitquot;, IF(F5=quot;Admitquot;, quot;APPLICANT ACCEPTEDquot;,
quot;APPLICANT DENIEDquot;)))))))

Thats my wonderful forumal. It odens't work.

Basically what i think it says is quot;If any cells through b19:f19 =
quot;incorrect figurequot; 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: www.excelforum.com/member.php...oamp;userid=31721
View this thread: www.excelforum.com/showthread...hreadid=516688pinehead,methinks too many IFs in the statement.

Try

=IF(B19:F19 = quot;Incorrect Figurequot;, quot;Refusedquot;, IF(OR(B19:F19 = quot;Perfect
Scorequot;, B5=quot;admitquot;,C5=quot;Admitquot;,D5=quot;Admitquot;, E5=quot;Admitquot;, F5=quot;Admitquot;),
quot;APPLICANT ACCEPTEDquot;, quot;APPLICANT DENIEDquot;))quot;pineheadquot; gt; wrote in
message news
gt;
gt; =IF(B19:F19 = quot;Incorrect Figurequot;, quot;Refusedquot;, IF(B19:F19 = quot;Perfect
gt; Scorequot;, quot;Applicant Acceptedquot;, IF(B5=quot;admitquot;, IF(C5=quot;Admitquot;,
gt; IF(D5=quot;Admitquot;, IF(E5=quot;Admitquot;, IF(F5=quot;Admitquot;, quot;APPLICANT ACCEPTEDquot;,
gt; quot;APPLICANT DENIEDquot;)))))))
gt;
gt; Thats my wonderful forumal. It odens't work.
gt;
gt; Basically what i think it says is quot;If any cells through b19:f19 =
gt; quot;incorrect figurequot; than refused, else check to see if any of the cells
gt; in b19:f19 =perfect score then accept, and if not then check each
gt; individual criteria.
gt;
gt; But it doenst work.
gt; Suggestions?
gt;
gt;
gt; --
gt; pinehead
gt; ------------------------------------------------------------------------
gt; pinehead's Profile:
gt; www.excelforum.com/member.php...oamp;userid=31721
gt; View this thread: www.excelforum.com/showthread...hreadid=516688
gt;

i'm still getting a #value. Any suggestions on what that may mean?--
pinehead
------------------------------------------------------------------------
pinehead's Profile: www.excelforum.com/member.php...oamp;userid=31721
View this thread: www.excelforum.com/showthread...hreadid=516688
=IF(B5:E19=quot;Incorrect Figurequot;,quot;Applicant Refusedquot;, quot;Acceptequot;)

This function alone does not work. says #value. Suggestions?--
pinehead
------------------------------------------------------------------------
pinehead's Profile: www.excelforum.com/member.php...oamp;userid=31721
View this thread: www.excelforum.com/showthread...hreadid=516688=IF(COUNTIF(B19:F19,quot;Incorrect Figurequot;)gt;0,quot;Refusedquot;,
IF(COUNTIF(B19:F19,quot;Perfect Scorequot;)gt;0,quot;Acceptquot;,
IF(OR(B5=quot;admitquot;,C5=quot;Admitquot;,D5=quot;Admitquot;,E5=quot;Admitquot;, F5=quot;Admitquot;),quot;APPLICANT
ACCEPTEDquot;,quot;APPLICANT DENIEDquot;)))--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

quot;Beegequot; gt; wrote in message
...
gt; pinehead,
gt;
gt;
gt; methinks too many IFs in the statement.
gt;
gt; Try
gt;
gt; =IF(B19:F19 = quot;Incorrect Figurequot;, quot;Refusedquot;, IF(OR(B19:F19 = quot;Perfect
gt; Scorequot;, B5=quot;admitquot;,C5=quot;Admitquot;,D5=quot;Admitquot;, E5=quot;Admitquot;, F5=quot;Admitquot;),
gt; quot;APPLICANT ACCEPTEDquot;, quot;APPLICANT DENIEDquot;))
gt;
gt;
gt; quot;pineheadquot; gt; wrote
in
gt; message news
gt; gt;
gt; gt; =IF(B19:F19 = quot;Incorrect Figurequot;, quot;Refusedquot;, IF(B19:F19 = quot;Perfect
gt; gt; Scorequot;, quot;Applicant Acceptedquot;, IF(B5=quot;admitquot;, IF(C5=quot;Admitquot;,
gt; gt; IF(D5=quot;Admitquot;, IF(E5=quot;Admitquot;, IF(F5=quot;Admitquot;, quot;APPLICANT ACCEPTEDquot;,
gt; gt; quot;APPLICANT DENIEDquot;)))))))
gt; gt;
gt; gt; Thats my wonderful forumal. It odens't work.
gt; gt;
gt; gt; Basically what i think it says is quot;If any cells through b19:f19 =
gt; gt; quot;incorrect figurequot; than refused, else check to see if any of the cells
gt; gt; in b19:f19 =perfect score then accept, and if not then check each
gt; gt; individual criteria.
gt; gt;
gt; gt; But it doenst work.
gt; gt; Suggestions?
gt; gt;
gt; gt;
gt; gt; --
gt; gt; pinehead
gt; gt; ------------------------------------------------------------------------
gt; gt; pinehead's Profile:
gt; gt; www.excelforum.com/member.php...oamp;userid=31721
gt; gt; View this thread:
www.excelforum.com/showthread...hreadid=516688
gt; gt;
gt;
gt;
Thanks, Bob

Pinehead, you may notice that spelling, capitalization, punctuation all
matter here. Below you see quot;admitquot; and quot;Admitquot;. 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

Beegequot;Bob Phillipsquot; lt;bob.phillips@not

heretiscali.co.ukgt; wrote in message
...
gt; =IF(COUNTIF(B19:F19,quot;Incorrect Figurequot;)gt;0,quot;Refusedquot;,
gt; IF(COUNTIF(B19:F19,quot;Perfect Scorequot;)gt;0,quot;Acceptquot;,
gt; IF(OR(B5=quot;admitquot;,C5=quot;Admitquot;,D5=quot;Admitquot;,E5=quot;Admitquot;, F5=quot;Admitquot;),quot;APPLICANT
gt; ACCEPTEDquot;,quot;APPLICANT DENIEDquot;)))
gt;
gt;
gt; --
gt;
gt; HTH
gt;
gt; Bob Phillips
gt;
gt; (remove nothere from the email address if mailing direct)
gt;
gt; quot;Beegequot; gt; wrote in message
gt; ...
gt;gt; pinehead,
gt;gt;
gt;gt;
gt;gt; methinks too many IFs in the statement.
gt;gt;
gt;gt; Try
gt;gt;
gt;gt; =IF(B19:F19 = quot;Incorrect Figurequot;, quot;Refusedquot;, IF(OR(B19:F19 = quot;Perfect
gt;gt; Scorequot;, B5=quot;admitquot;,C5=quot;Admitquot;,D5=quot;Admitquot;, E5=quot;Admitquot;, F5=quot;Admitquot;),
gt;gt; quot;APPLICANT ACCEPTEDquot;, quot;APPLICANT DENIEDquot;))
gt;gt;
gt;gt;
gt;gt; quot;pineheadquot; gt; wrote
gt; in
gt;gt; message news
gt;gt; gt;
gt;gt; gt; =IF(B19:F19 = quot;Incorrect Figurequot;, quot;Refusedquot;, IF(B19:F19 = quot;Perfect
gt;gt; gt; Scorequot;, quot;Applicant Acceptedquot;, IF(B5=quot;admitquot;, IF(C5=quot;Admitquot;,
gt;gt; gt; IF(D5=quot;Admitquot;, IF(E5=quot;Admitquot;, IF(F5=quot;Admitquot;, quot;APPLICANT ACCEPTEDquot;,
gt;gt; gt; quot;APPLICANT DENIEDquot;)))))))
gt;gt; gt;
gt;gt; gt; Thats my wonderful forumal. It odens't work.
gt;gt; gt;
gt;gt; gt; Basically what i think it says is quot;If any cells through b19:f19 =
gt;gt; gt; quot;incorrect figurequot; than refused, else check to see if any of the cells
gt;gt; gt; in b19:f19 =perfect score then accept, and if not then check each
gt;gt; gt; individual criteria.
gt;gt; gt;
gt;gt; gt; But it doenst work.
gt;gt; gt; Suggestions?
gt;gt; gt;
gt;gt; gt;
gt;gt; gt; --
gt;gt; gt; pinehead
gt;gt; gt; ------------------------------------------------------------------------
gt;gt; gt; pinehead's Profile:
gt;gt; gt; www.excelforum.com/member.php...oamp;userid=31721
gt;gt; gt; View this thread:
gt; www.excelforum.com/showthread...hreadid=516688
gt;gt; gt;
gt;gt;
gt;gt;
gt;
gt;