Nesting formulas

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Nesting formulas 0
Repeat data 1
Repeating cells 1
Nesting formulas 1
Aligning related data 3
Combining an IF with another formula 4
VBA Export to PDF 0
Nesting Eroor - more than 64 3

Top