Remove the "False" from Statement

Hi All

I have created the following forumula:

=IF(AND($W2>=3,$W2<4),"Greater than 2 Year Old")

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($W2>=3,$W2<4),"Greater than 2 Year Old","")

In article <[email protected]>,
Hardip <[email protected]> wrote:

> Hi All
>
> I have created the following forumula:
>
> =IF(AND($W2>=3,$W2<4),"Greater than 2 Year Old")
>
> 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

IF(AND($W2>=3,$W2<4),"Greater than 2 Year Old")
IF(AND($W2>=3,$W2<4),"Greater than 2 Year Old","")


--
Don Guillett
SalesAid Software
[email protected]
"Hardip" <[email protected]> wrote in message
news:[email protected]...
> Hi All
>
> I have created the following forumula:
>
> =IF(AND($W2>=3,$W2<4),"Greater than 2 Year Old")
>
> 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

Thanks - I feel stupid now!!!



"JE McGimpsey" wrote:

> One way:
>
> =IF(AND($W2>=3,$W2<4),"Greater than 2 Year Old","")
>
> In article <[email protected]>,
> Hardip <[email protected]> wrote:
>
> > Hi All
> >
> > I have created the following forumula:
> >
> > =IF(AND($W2>=3,$W2<4),"Greater than 2 Year Old")
> >
> > 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
>