Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
=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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Order of selecting unprotected cells | Excel Discussion (Misc queries) | |||
how do you "select locked cells" w/o "select unlocked cells"? | Excel Discussion (Misc queries) | |||
Locked cells not updating | Excel Worksheet Functions | |||
Help adding text values | Excel Worksheet Functions | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions |