=IF(AND(C1=01,D1="A"),"Broken Drive Belt",IF(AND(C1=03,D1="B"),"Drive Chain
Off","")

However, if there are a large number of possible combinations, then there
maybe better solutions. For example a "LOOKUP" based on a combined key of C1
& D1


HTH

"mulligbo" wrote:

Ok, big question. Hopefully you can understand what I am asking.

I have colum C that has #s 01 - 15 in it and they are random numbers.
In column D I have Letters A-I and they are random too.

I want to put in column E an IF statement.

Here is an example of what I want using the data that I am working on.

First off in column C, 01 would represent Drive Belts
03 would be Drive Chains
In column D, Letter A would be Broken
B would be Off

And there are a lot more.

How could I make Column E say IF (C1=01 AND D1=A, Broken Drive Belt )
IF(C1=03 And D1=B, Drive Chain Off)

Any help is appreciated.

Thanks.