G
gcotterl
How do I nest these formulas in one cell:
=IF(MID(D6,4,1)="-"
IF(M6="J",TEXT(0,"0000000"),TEXT("0"&LEFT(D6,2)&MID
(D6,4,4),"0000000")
IF(M6="G","XXXXXX","yyyyy")
IF(M6="U",TEXT(0,"0000000"),TEXT(0,"0000000")
=IF(MID(D6,4,1)="-"
IF(M6="J",TEXT(0,"0000000"),TEXT("0"&LEFT(D6,2)&MID
(D6,4,4),"0000000")
IF(M6="G","XXXXXX","yyyyy")
IF(M6="U",TEXT(0,"0000000"),TEXT(0,"0000000")