Nesting formulas

G

gcotterl

How do I nest these formulas into 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
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
Use cell value to adjust date range 2
VBA Coding Help for Beginner 0

Top