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

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.

CARBOB

Well-known Member
Joined
Jun 6, 2005
Messages
1,860

ADVERTISEMENT

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 :)
 

Watch MrExcel Video

Forum statistics

Threads
1,108,481
Messages
5,523,203
Members
409,504
Latest member
Joshcurrie

This Week's Hot Topics

Top