Formula Help

CARBOB

Well-known Member
Joined
Jun 6, 2005
Messages
1,860
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 Workbook
AFAGAHAIAJAKALAMANAO
10714242733MDNMDNDEVMDNDOD
22529303335MDNMDNMDNDODDOD
30612152227DEVMDNDODDEVMDN
40517232432MDNDODMDNDEVMDN
Sheet4
Excel 2007
 

Some videos you may like

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.

CARBOB

Well-known Member
Joined
Jun 6, 2005
Messages
1,860
what should happen when 1 digit is 0?
The digits range from 1-36. Digits 1-9 custom formatted "00", to show as 2 digits. Digits 2,4,6,8 = DEV;DIGITS 1,3,5,7,9 =DOD
 
Last edited:

bobsan42

Well-known Member
Joined
Jul 14, 2010
Messages
1,343
put this in AK1 and fill right and down:

=CHOOSE(IF(MOD(AF1,2),1,2)+IF(MOD(INT(AF1/10),2),1,2),,"DOD","MDN","DEV")

let us know :)
 

Subscribe on YouTube

Watch MrExcel Video

Forum statistics

Threads
1,105,943
Messages
5,508,278
Members
408,673
Latest member
CELER_

This Week's Hot Topics

Top