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

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN

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,931
Messages
5,525,684
Members
409,660
Latest member
1817538628

This Week's Hot Topics

Top