Trying to use one formula for a variety logical tests. Is it possible to write:
=IF(Logical Test, Value if True, Value if False)
=If(A1=("ABC" OR "BCD" OR "CDE" OR "DEF"),("ABC"="123","BCD"="234","CDE"="345","DEF"="456"),"IT'S BROKEN")
If you view the attached spreadsheet and see my progression and the end result it will probably make more sense. I also may need to use IF LEFT() for the final data I'm working with.
I'm totally stumped on this one.
Thx for any help. This forum is awesome!!!
Running XP Pro/Excel 2003 (have access to 2007)
Bookmarks