software

Hi All

I have created the following forumula:

=IF(AND($W2gt;=3,$W2lt;4),quot;Greater than 2 Year Oldquot;)

What I want to do is leave the cell blank - I Don't want a 'space' or the
FALSE written in the cell. How do I remove this?

I'd appreciate any pointers.

TIA - H

One way:

=IF(AND($W2gt;=3,$W2lt;4),quot;Greater than 2 Year Oldquot;,quot;quot;)

In article gt;,
Hardip gt; wrote:

gt; Hi All
gt;
gt; I have created the following forumula:
gt;
gt; =IF(AND($W2gt;=3,$W2lt;4),quot;Greater than 2 Year Oldquot;)
gt;
gt; What I want to do is leave the cell blank - I Don't want a 'space' or the
gt; FALSE written in the cell. How do I remove this?
gt;
gt; I'd appreciate any pointers.
gt;
gt; TIA - H

IF(AND($W2gt;=3,$W2lt;4),quot;Greater than 2 Year Oldquot;)
IF(AND($W2gt;=3,$W2lt;4),quot;Greater than 2 Year Oldquot;,quot;quot;)--
Don Guillett
SalesAid Software

quot;Hardipquot; gt; wrote in message
...
gt; Hi All
gt;
gt; I have created the following forumula:
gt;
gt; =IF(AND($W2gt;=3,$W2lt;4),quot;Greater than 2 Year Oldquot;)
gt;
gt; What I want to do is leave the cell blank - I Don't want a 'space' or the
gt; FALSE written in the cell. How do I remove this?
gt;
gt; I'd appreciate any pointers.
gt;
gt; TIA - H

try =IF(AND($W2gt;=3,$W2lt;4),quot;Greater than 2 Year Oldquot;,quot;quot;)--
barrfly

Excel User - Energy markets
------------------------------------------------------------------------
barrfly's Profile: www.excelforum.com/member.php...foamp;userid=4141
View this thread: www.excelforum.com/showthread...hreadid=527166Thanks - I feel stupid now!!!
quot;JE McGimpseyquot; wrote:

gt; One way:
gt;
gt; =IF(AND($W2gt;=3,$W2lt;4),quot;Greater than 2 Year Oldquot;,quot;quot;)
gt;
gt; In article gt;,
gt; Hardip gt; wrote:
gt;
gt; gt; Hi All
gt; gt;
gt; gt; I have created the following forumula:
gt; gt;
gt; gt; =IF(AND($W2gt;=3,$W2lt;4),quot;Greater than 2 Year Oldquot;)
gt; gt;
gt; gt; What I want to do is leave the cell blank - I Don't want a 'space' or the
gt; gt; FALSE written in the cell. How do I remove this?
gt; gt;
gt; gt; I'd appreciate any pointers.
gt; gt;
gt; gt; TIA - H
gt;