Making one cell display multiple things

[abxy]

If I knew anything about coding checkboxes in excel, then this problem
probably wouldn't exist, but unfortunately i don't, so here goes:

Ok, if cell B1 isn't blank, then I need Cell A1 to display "damaged".
If cell C1 isn't blank then I need Cell A1 to display "defective"
(what'd be really good, but probably hard to do, is also make some way
so that both cells, B1 and C1, are never both not blank)


the other problem (this is a separate problem, but related) is this:
cells A1 to A5 are blank. Cells B1 to B5 have words in them (glove,
hat, shoe, etc.). I need to make it so that if a cell in column A isn't
blank, then the word next to it in column B shows up in C1.

How do i accomplish these things?

Thanks in advance for your help, i really appreciate it. : )

 

[rbrychckn]

ok. First, I'm assuming if B1 AND C1 are both filled in, you wan
"Damaged/Defective" in A1. If so, here's one answer to #1--I don'
have an answer for #2, that would require some programming in VBA

=IF(ISBLANK(B1),IF(ISBLANK(C1),"","Defective"),IF(ISBLANK(C1),"Damaged","Damaged/Defective")