Compare two 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

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..

Try:
=IF(C10,IF(B1<=0,"Waxie","Bob Barker"),"Bob Barker")

Hope this is what you want. If not, ask again.
Bob


--
jahoobob