Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If and And formula
=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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|