If and And formula
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. |
All times are GMT +1. The time now is 10:16 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com