software

=IF('M ORQ Rec'!B2=0,0,IF('M ORQ Rec'!B2gt;=12,20,IF('M ORQ
Rec'!B2gt;=10,18,IF('M ORQ Rec'!B2gt;=7,16,IF('M ORQ
Rec'!B2lt;=6,15,quot;Nquot;)))))

I want it to display N if there is text in B2, but it always shows 20
instead. Thanks--
LucasBuck
------------------------------------------------------------------------
LucasBuck's Profile: www.excelforum.com/member.php...oamp;userid=19710
View this thread: www.excelforum.com/showthread...hreadid=500793Try this:

=IF(ISTEXT(B2),quot;Nquot;,IF(B2=0,0,IF(B2gt;=12,20,IF(B2gt;=1 0,18,IF(B2gt;=7,16,IF(B2lt;=6,15,0))))))

HTH
JG

quot;LucasBuckquot; wrote:

gt;
gt; =IF('M ORQ Rec'!B2=0,0,IF('M ORQ Rec'!B2gt;=12,20,IF('M ORQ
gt; Rec'!B2gt;=10,18,IF('M ORQ Rec'!B2gt;=7,16,IF('M ORQ
gt; Rec'!B2lt;=6,15,quot;Nquot;)))))
gt;
gt; I want it to display N if there is text in B2, but it always shows 20
gt; instead. Thanks
gt;
gt;
gt; --
gt; LucasBuck
gt; ------------------------------------------------------------------------
gt; LucasBuck's Profile: www.excelforum.com/member.php...oamp;userid=19710
gt; View this thread: www.excelforum.com/showthread...hreadid=500793
gt;
gt;

You could rewrite your equation like this:

=if(istext('M ORQ Rec'!B2),quot;Nquot;,IF('M ORQ Rec'!B2=0,0,IF('M ORQ
Rec'!B2gt;=12,20,IF('M ORQ Rec'!B2gt;=10,18,IF('M ORQ Rec'!B2gt;=7,16,IF('M ORQ
Rec'!B2lt;=6,15))))))

HTH,
Elkar
quot;LucasBuckquot; wrote:

gt;
gt; =IF('M ORQ Rec'!B2=0,0,IF('M ORQ Rec'!B2gt;=12,20,IF('M ORQ
gt; Rec'!B2gt;=10,18,IF('M ORQ Rec'!B2gt;=7,16,IF('M ORQ
gt; Rec'!B2lt;=6,15,quot;Nquot;)))))
gt;
gt; I want it to display N if there is text in B2, but it always shows 20
gt; instead. Thanks
gt;
gt;
gt; --
gt; LucasBuck
gt; ------------------------------------------------------------------------
gt; LucasBuck's Profile: www.excelforum.com/member.php...oamp;userid=19710
gt; View this thread: www.excelforum.com/showthread...hreadid=500793
gt;
gt;


Thank you both very much--
LucasBuck
------------------------------------------------------------------------
LucasBuck's Profile: www.excelforum.com/member.php...oamp;userid=19710
View this thread: www.excelforum.com/showthread...hreadid=500793