Syntax for multiple if/and formula

[Omegaman2]

I know this has to already be here somewhere, but I cannot find it, so sorry for asking, but thanks for the help.

I am using Excel 2010

I am needing a formula that checks several cells for true, then gives a result.

For example, if b2="word1" AND if b3="word2" AND b4=1234 AND b5=5678 AND b6=c1+c2 then "Correct"

I hope that was clear, not sure how to express it in English, let alone in Excelese!

Thanks Again!

[sandy666]

you did it
=IF(AND(B2="word1",B3="word2",B4=1234,B5=5678,B6=(C1+C2)),"Correct","Icorrect")

IF()
AND()

[Omegaman2]

Hmmm, I replied once, does not seemed to have taken. I tried this, and it did not quite work, I suspect I misunderstood. However, I took this and with some minor teaking, it worked great, I had an issue with balancing the parenths. I think it was because I monkeyed with it to suit my exact situation, not quite like the example I provided. Thanks a lot Sandy!

[sandy666]

You are welcome

Have a nice day