"FALSE" in cell

[Blair]

Hi All,

I'm tracking the 5 out of the 6 plus bonus number in a lottery and was
wondering

how can I hide the false statement I'm getting in a cell. Here's the formula
I'm using,

=IF(O2=5,IF(G2="Yes","WINNER",0)) The result is going into Q2.

I enter the regular numbers in A17,F17 and the bonus number into O17.

O2 tells me if I've matched 5 numbers, and G2 tells me if I've matched the
bonus number.

With this formula, I can get it to work, but when there isn't any numbers
entered, I, of course, get the "FALSE", statement. Is there an easier way to
do this with a better formula, or can I just somehow hide the "FALSE"
statement in the cell.

Thanks in advance for any help.

Blair

 

[Orlando Magalhães Filho]

Hi Blair,

Try this:
=IF(O2=5,IF(G2="Yes","WINNER",0),"")


HTH

 

[Blair]

Excellent. Thanks very much for your response, J.E. it works like a charm.

 

[Paul B]

Blair, here is one way =IF(AND(O2=5,G2="Yes"),"WINNER","")

--
Paul B
Always backup your data before trying something new
Using Excel 2000 & 97
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **

 

[Blair]

Thanks very much,Orlando, works great.

 

[Blair]

Thanks Paul, I tried your suggestion too, and it works great. Being a newbie
with Excel, I really appreciate all the help from everyone, thanks again.