Compare to cells to evoke a response

Here is the problem..


Waxie Bob Barker
(c) (d) (e)
(1) 0 12 = Bob barker
(2) 15 0 = Waxie
(3) 201 0 = Waxie
(4) 0 108 = Bob Barker

I am trying to compare two cells of the same row. If the value of c1 is
0 or false and the value of d1 it true or has a numeric value then I
want xl to display a word like "Waxie" . If some could help with this
equation that would be GREAT.. Thanks
Tried If(c1=true,"Waxie","Bob Barker") This did not work..


--
Custermd

=IF(AND((OR(C1=0,C1=FALSE)),(OR(D1=TRUE,ISNUMBER(D1)))),"Waxie","bob barker")
or maybe
=IF(AND((OR(AND(ISNUMBER(C1),C1=0),C1=FALSE)),(OR(D1=TRUE,ISNUMBER(D1)))),
"Waxie","bob barker")
(all one cell)

An empty cell will be treated as 0

Custermd wrote:
>
> Here is the problem..
>
> Waxie Bob Barker
> (c) (d) (e)
> (1) 0 12 = Bob barker
> (2) 15 0 = Waxie
> (3) 201 0 = Waxie
> (4) 0 108 = Bob Barker
>
> I am trying to compare two cells of the same row. If the value of c1 is
> 0 or false and the value of d1 it true or has a numeric value then I
> want xl to display a word like "Waxie" . If some could help with this
> equation that would be GREAT.. Thanks
> Tried If(c1=true,"Waxie","Bob Barker") This did not work..
>
> --
> Custermd

--

Dave Peterson