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(D 1)))),"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