Formula Help

[CARBOB]

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

Excel 2007

 

[SteveO59L]

So, is the entry in AF1

07 or 7 ?

 

[bobsan42]

what should happen when 1 digit is 0?

 

[CARBOB]

So, is the entry in AF1

07 or 7 ?

A 7 custom formatted to show 07 as 2 digits, "00"

 

[CARBOB]

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

 

[bobsan42]

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

 

[CARBOB]

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

Works like a charm, thank you very much!!!