"FALSE" in cell

  • Thread starter Thread starter Blair
  • Start date Start date
B

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
 
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 **
 
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.
 
Back
Top