The values in AF:AJ are custom formatted, "00". I need a formula in columns AK:AO that returns MDN, if the value is one odd/ one even; return DOD, if the value is two odd digits; return DEV, if the value is two even digits.
Excel 2007
Excel Workbook | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
AF | AG | AH | AI | AJ | AK | AL | AM | AN | AO | |||
1 | 07 | 14 | 24 | 27 | 33 | MDN | MDN | DEV | MDN | DOD | ||
2 | 25 | 29 | 30 | 33 | 35 | MDN | MDN | MDN | DOD | DOD | ||
3 | 06 | 12 | 15 | 22 | 27 | DEV | MDN | DOD | DEV | MDN | ||
4 | 05 | 17 | 23 | 24 | 32 | MDN | DOD | MDN | DEV | MDN | ||
Sheet4 |