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

"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.