troubleshooting Question

Excel IF Statement and returning multiple cell contents

Avatar of esu4236
esu4236Flag for United States of America asked on
Microsoft Excel
8 Comments1 Solution380 ViewsLast Modified:
I'm trying to use an IF statement with nested IF's, and I also want to return TWO cells for the TRUE parts of my statements; i.e., for the first IF, I want cells C3 and C4 and then a comma and space after that.  However, it doesn't seem to be picking up all the data; it's like picking up only the first column that has a number larger than 0 and then the last column, Column K.  Here's my IF statement:

=IF(C4>0,$C$3&C4&", ",IF(D4>0,$D$3&D4&", ",IF(E4>0,$E$3&E4&", ",IF(F4>0,$F$3&F4&", ",IF(G4>0,$G$3&G4&", ",IF(H4>0,$H$3&H4&", ",IF(I4>0,$I$3&I4&", "," ")))))))&(IF(J4>0,$J$3&J4&", ",IF(K4>0,$K$3&K4,"")))

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 8 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 8 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros