software

I have created the following formula:

=IF(Q12gt;=94,quot;5.7quot;,IF(Q12gt;=86,quot;5.3quot;,IF(Q12gt;=78,quot;5.0 quot;,IF(Q12gt;=69,quot;4.7quot;,IF(Q12gt;=59,quot;4.3quot;,IF(Q12gt;=49,quot;4. 0quot;,IF(Q12gt;=41,quot;3.7quot;,IF(Q12gt;=21,quot;3.0quot;,2))))))))

but I really want to add one or two more IF statements. It does not seem to
be possible.

Any suggestions


if it doesn't let you then there are three choices.
1. split the formula into two
2. set the break points and values in a table and do a vlookup
3 code the statement in vba as a formula and reference that

any preferences--
tony h
------------------------------------------------------------------------
tony h's Profile: www.excelforum.com/member.php...oamp;userid=21074
View this thread: www.excelforum.com/showthread...hreadid=5019847 nested statements is your limit. Try this

=VLOOKUP(Q12,{0,2;22,3;42,3.7;50,4;60,4.3;70,4.7;7 9,5;87,5.3;95,5.7},2)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;Paul Pquot; lt;Paul gt; wrote in message
...
gt; I have created the following formula:
gt;
gt;
=IF(Q12gt;=94,quot;5.7quot;,IF(Q12gt;=86,quot;5.3quot;,IF(Q12gt;=78,quot;5.0 quot;,IF(Q12gt;=69,quot;4.7quot;,IF(Q12gt;
=59,quot;4.3quot;,IF(Q12gt;=49,quot;4.0quot;,IF(Q12gt;=41,quot;3.7quot;,IF(Q12 gt;=21,quot;3.0quot;,2))))))))
gt;
gt; but I really want to add one or two more IF statements. It does not seem
to
gt; be possible.
gt;
gt; Any suggestions