How do I use multiple cells with text in an 'if' statement in excel?

Question

Basically, I'm trying to get one cell to tell me "complete" if cell a3,a4,a5,a6 each has the text "done" in it. I've figured out how I can write this up for numerical values but not text values.

i think NotEasilyFooled got it. I tested the suggestion and it gave me the result I needed, which was multiple cells all having the same value in my logic portion of the If statement. As soon as the 24 hours are up I'll give him/her the best answer.

Answer 1

It would be something like this...

=if(and(a3="done",a4="done",a5="done",
a6="done"),"complete","NOT")

Answer 2

If all the cells, a3,a4,a5,a6 must contain "done" and be true:

=(if(and(a3,a4,a5.a6="done", "complete", "")))
I do hope the prenthesis are correct., since I have not tested this in Excel.
This translates as, if a3 = done, and a4 = done, and a5= done, and a6= done, (all true), then print "complete", otherwise ( " " ) print a void, if any one cell is false.
You could have it print "not done"., or anything else. Be sure that "text" contains enclosed quotes, unlike numbers. To print a void is just a double quote only. ( " " )

If you wanted an "OR" statement, it is written the same way. This would answer if any cell was true. Sub "OR" for "AND".

Answer 3

Here's what you need to put in the cell:

=IF(AND(A3 = "done", A4 = "done", A5 = "done", A6 = "done"), "complete", "not complete")

Or this could also work:

=IF(A3 = "done", IF(A4 = "done", IF(A5 = "done", IF(A6 = "done", "complete", "not complete"), "not complete"), "not complete"), "not complete")

You can replace the text "not complete" with whatever you want it to say whenever all of the cells don't show "done".

I tested both formulas and they work. If you do it like Edward said, when you delete one of the done's, it will not update like the two formulas I gave will. It will still show complete, even though done is missing in one of the cells.

Answer 4

go to help.......search for formulas........... a box will open.....Worksheet functions listed by category...............Text and Data at the bottom